Re: Y2K problem with sysdate

>probe
>EXEC SQL select to_char(sysdate,'dd/mm/yyyy') into :today from dual;
>printf("Today is %s \n", today.arr);
>
>note: The format 'dd/mm/yyyy' replace with you prefered, 'yyyy-mon-dd',
>yyyymmdd,etc

--
        Dagoberto Navea Alfaro
Ingeniero en Computación e Informática
          Analista de Sistemas
Unidad de Informática y Comunicaciones
          Universidad Arturo Prat
I               quique - Chile
"Solo pido a Dios fortaleza para cambiar las cosas
  que puedo, resignación para aquellas que no puedo
  y sabiduria para diferenciarlas"

Deepa Dinendra escribió en mensaje <3873B780.83DC432B_at_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