Y2K problem with sysdate

From: Deepa Dinendra <deepa_dinendra_at_psmfc.org>
Date: Wed, 05 Jan 2000 15:28:32 -0600
Message-ID: <3873B780.83DC432B_at_psmfc.org>



Hi,
[Quoted] [Quoted] My Pro*c programs which were not having any problems with dates before [Quoted] [Quoted] 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 - 22:28:32 CET

Original text of this message