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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Y2K problem with sysdate

Re: Y2K problem with sysdate

From: Dagoberto Navea Alfaro <dago_at_cec.unap.cl>
Date: Mon, 10 Jan 2000 18:47:00 -0400
Message-ID: <85dn53$73o$1@manutara.inf.utfsm.cl>


>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
Received on Mon Jan 10 2000 - 16:47:00 CST

Original text of this message

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