Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Y2K problem with sysdate
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 - 15:28:32 CST