Strange Problem

[srinivasan.seetharaman@DB.COM]

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.