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 -> Re: Year 2000 problem with SQL *Net?

Re: Year 2000 problem with SQL *Net?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Fri, 19 Nov 1999 15:39:50 -0800
Message-ID: <814n55$fih$1@plo.sierra.com>

add the following command to your INITxxx.ora configuration file (asap): =

NLS_DATE_FORMAT = 'DD-MMM-YYYY' or NLS_DATE_FORMAT = 'DD-MMM-RR'

Locate and edit your login.sql file (for SQL*PLUS) which is in
c:\orawin\dbs\LOGIN.SQL
or
c:\orant\dbs\login.sql
or
c:\orawin95\dbs\login.sql

add:
alter session set nls_date_format = 'DD-MON-YYYY'; or
alter session set nls_date_format = 'DD-MON-RR';

DistressedCanadian <beck4353NObeSPAM_at_yahoo.com.invalid> wrote in message = news:17599f0b.332250d0_at_usw-ex0102-015.remarq.com...
> I am accessing an Oracle7 Database through SQL *Net. When I run a
> query to get all results between yesterday and christmas, I get =
results
> from yesterday and today. When I do the same query with an end date =
of
> christmas 2000, I get no results at all.
>
> We are storing dates in the form 'DD-MMM-YY'
>
> Is there some command to enter to get the date of 00 to be recognized?
> When I try usin '2000' I get an error, so it must be in 2 digit =
format.
>
>
> * 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 Fri Nov 19 1999 - 17:39:50 CST

Original text of this message

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