Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Integrating an Oracle database with SQL statements

Integrating an Oracle database with SQL statements

From: Kinna Patel <kinna_at_qmark.co.uk>
Date: Wed, 02 Jun 1999 14:46:15 GMT
Message-ID: <375542ed.24728932@news.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US