Re: Integrating an Oracle database with SQL statements

Hi Kinna,

    Until Nirvana comes date standardization is unlikely between and among the various RDBMS. You have two choices -- assuming that you can't dump those other RDBMS and use only Oracle ;-)

    You can modify your SQL code for each occurrence of the date.

    You can develop a stored procedure for each RDBMS where the stored procedure will have a common name and the same arguments in each RDBMS. Then modify your SQL one time to call the stored procedure.

regards

Jerry Gitomer

Kinna Patel wrote in message <375542ed.24728932_at_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 Thu Jun 03 1999 - 10:46:04 CDT