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
are you sure that someone didn't make a change to nls_date_format in your
init<sid>.ora file?
Received on Thu Jan 06 2000 - 06:38:00 CST
