Re: Strange Problem

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

What database u are on?
Read/see document related to RR (centurey) format/mask for Date.

HTH,
Manoj


>From: srinivasan.seetharaman@DB.COM
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Strange Problem
>Date: Wed, 5 Jan 2000 14:22:48 +0530
>
>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.

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com