Re: Strange Problem

["Mani, Bharati" <Bharati_Mani@WRIGHTEXPRESS.COM>]

Hi
   while inserting the date into a date field use tha mask 'dd-mon-rr'
e.g
insert into table_name  values( ....
                                to_date(&c_dt, 'dd-mon-rr')
HTH
Bharathi

> -----Original Message-----
> From: srinivasan.seetharaman@DB.COM [SMTP:srinivasan.seetharaman@DB.COM]
> Sent: Wednesday, January 05, 2000 3: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.