We just upgraded our Oracle drivers here, and are having
many problems with Dates. It seems that you can no longer
compare using >, <, >=, <=. The following SQL statement
works with the older driver, but not now:
SELECT E1.REQUEST_NUMBER as REQUEST,
E1.SUBMIT_DATE
FROM ID_ENTRY_1 E1,
ID_ENTRY_1 EDF,
ID_ENTRY_1 EDT
WHERE E1.CLIENT = 6002
AND E1.REQUEST_NUMBER = EDF.REQUEST_NUMBER(+)
AND EDF.SUBMIT_DATE >= to_date('1999-06-01 00:00:00',
'YYYY-MM-DD HH24:MI:SS')
AND E1.REQUEST_NUMBER = EDT.REQUEST_NUMBER(+)
AND EDT.SUBMIT_DATE <= to_date('1999-09-28 23:59:59',
'YYYY-MM-DD HH24:MI:SS')
Please let me know how to update this to the *new* standard
- it doesn't seem to be in the DOCS.
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Received on Tue Sep 28 1999 - 14:26:31 CDT
