Re: Strange Problem

[Reinier de Ruiter <Reinier.deRuiter@APOLLOGRP.EDU>]

Haven't done your y2k testing have you ? :-))

Anyways, we had a similar situation. It turns out the nls-date format is set
to dd-mon-yy and Oracle automatically adds the current century to it (2000)
and that's why you get 2099 instead of 1999. Change your nls-date format to
dd-mon-yyyy which will probably give you problems elsewhere in the code. In
your situation I would use the dd-mon-rr in your edit-mask. The rr will
cause Oracle to convert 99 into 1999. (50-99 will be converted into
1950-1999 and 00-49 will be converted into 2000-2049)

good luck,

Reinier de Ruiter
Peoplesoft Programmer/Analyst
Apollo Group, University of Phoenix
Phoenix, Arizona
tel:480-557-1158
email: reinier.deruiter@apollogrp.edu



-----Original Message-----
From: srinivasan.seetharaman@DB.COM
[mailto:srinivasan.seetharaman@DB.COM]
Sent: Wednesday, January 05, 2000 1:53 AM
To: SQR-USERS@list.iex.net
Subject: Strange Problem


Hello All,
     I have a strange problem. I have a SQL statement in SQR. I select a
date
from a table .Take for instance the date is c_dt, the database variable is
referenced as &c_dt.

In the Insert statement in the same SQR , I'm inserting &c_dt into a date
field.
The insert executes successfully. But surprisingly , a date value(say
01-jun-1999') is inserted as ('01-jun-2099').

Could anyone throw some light on this ?. And let me know what the problem is
.
Even though &c_dt is not a date variable but a character variable , it
should
have populated it as 19yy instead of 20yy right ?.


Thanks in Advance.