Select statement where DATE

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Allen

    Select statement where DATE

    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
Working...