Re: Filtering dates using TO_DATE(). Is there an alternative.

From: Marcus Neppl <Marcus.Neppl_at_klinik.uni-regensburg.de>
Date: Fri, 03 Jul 1998 15:05:23 +0200
Message-ID: <359CD713.B880C90C@klinik.uni-regensburg.de>

You have to configure your Session-NLS-environment through the NLS_DATE_FORMAT-parameter in your ORACLE.INI-file or accordingly configuration-files on your client.
On your server you have to configure your initORACLE_SID.ora-file

Then the following should be possible: SELECT custid FROM XCB.TABLE WHERE DATE > '31-DEC-1997' or any else format for the date

Bruce Sutherland wrote:

> Is there an alternate method (through ODBC) for filtering rows based
> on dates other than the TO_DATE() function? Other data sources allow
> you to use the '#' character to delimit dates. For example, is there
> an alternative tothe following?
>
> SELECT custid FROM XCB.TABLE WHERE DATE >
> TO_DATE('31-DEC-1997','DD-MON-YYYY')
>
> TIA,
>
> Bruce
Received on Fri Jul 03 1998 - 08:05:23 CDT