I have a table with 67,000 records. One of the columns is a DATE data
type.
I wanted to find every record newer than 2002 but I can figure out the
correct SQL syntax.
I tried:
select * from my_table where LDATE >= 01/01/02
But that doesn't return the correct information. Again, the LDATE
column is a Date/Time data format (per MS-Access).
Could someone give me the correct syntax to pull this data?
Thanks
-Allen
type.
I wanted to find every record newer than 2002 but I can figure out the
correct SQL syntax.
I tried:
select * from my_table where LDATE >= 01/01/02
But that doesn't return the correct information. Again, the LDATE
column is a Date/Time data format (per MS-Access).
Could someone give me the correct syntax to pull this data?
Thanks
-Allen