SQL Query - Date Range

Results 1 to 3 of 3

Thread: SQL Query - Date Range

  1. #1
    Join Date
    Dec 1969

    Default SQL Query - Date Range

    I am trying to use the SQL Select statement to find records that have a date field that is after a certain date. I know how to search for a specific date, but what about any date after a specified date? I am using Oracle.<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default i think this will work!

    select * from mytable where datefield = 5/20/00<BR><BR>hope this helps!!

  3. #3
    Join Date
    Dec 1969

    Default > or >=...

    Should do the trick.<BR><BR>SELECT * FROM tablename WHERE datefield &#062;= TO_DATE(datevariable, &#039format&#039)<BR><BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts