Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Y2K problem with sysdate

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@psmfc.org>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US