Re: Problems with Dates in new Oracle

From: Arati Vijay <vijayj_at_singnet.com.sg>
Date: Sun, 3 Oct 1999 16:26:40 +0800
Message-ID: <7t746v$l4k$1@coco.singnet.com.sg>

I had a similar problem and thru this newsgroup realized that my NLS_DATE_FORMAT had been changed!

Mark MacRae <mNOmSPAM_at_witty.com.invalid> wrote in message news:033d8508.3b5d95b1_at_usw-ex0103-020.remarq.com...
> 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 Sun Oct 03 1999 - 03:26:40 CDT