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.
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