Re: Y2K problem with sysdate

What's your platform and OS?

What's your Oracle version number?

What's your default NLS date format? Since you appear to have a 15 character format, I am guessing 'DD-MON-YYHH:MI'. If you want a 4 digit year, use YYYY, to maintain a two digit year, use RR. If you expand to YYYY, you will need two extra characters in your varchar. Have you done any Y2K work on this at all?

Deepa Dinendra wrote:
>
> Hi,
> My Pro*c programs which were not having any problems with dates before
> 01-jan-2000 is failing where ever there is sysdate function call.
>
> I tried the following:
> today varchar[15];
>
> EXEC SQL select sysdate into :today from dual;
> printf("Today is %s \n", today.arr);
>
> The result I obtained is
> Today is 05-JAN-015:20
>
> Only day and month +time is shown, NO year since it is 00. Has anybody
> experienced problems with sysdate since 2000?
>
> Thanks
> -Deepa
Received on Wed Jan 05 2000 - 18:52:56 CST