Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Integrating an Oracle database with SQL statements
I have got the following SQL statement which will retrieve all the
records where date is > that 1/1/1998
Select * from R_List where Date > '6/2/1999 23:59:59'
This works fine when the database is Oracle but when the database is anything else then I get an error message.
What is the correct SQL for filtering on date fields which would work on all database types?
Thanks in advance for the help Received on Wed Jun 02 1999 - 09:46:15 CDT