-
I have a table that has data from JAN 1999.
I want to query on the invalid_date column
for data from August, 10 2001.
I am a bit confuesd on the(=< and =>)less than
and the greater than signs .
Based on this which of my syntaxes are right?
select * from hire_table where invalid_date '>=10-AUG-2001'
select * from hire_table where invalid_date '<=10-AUG-2001'
-
select * from hire_table where invalid_date '>=10-AUG-2001'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|