Re: *Time in SYSDATE out of sync*
Date: Mon, 10 Aug 1992 15:13:18 GMT
Message-ID: <1992Aug10.151318.26766_at_news.iastate.edu>
In article <9208071553.AA07755_at_artecon>,
ram%artecon_at_hp-sdd.sdd.hp.com writes:
>
>Hello World
>
> The `time' part in SYSDATE is thoroughly messed up.
> Here is the output captured from the `script' command
> of SunOS 4.1.2:
>
>
>Script started on Fri Aug 7 08:35:29 1992
>artemis% date
>Fri Aug 7 08:35:32 PDT 1992
>artemis% sqlplus
>
>SQL*Plus: Version 3.0.9.1.2 - Production on Fri Aug 7 08:35:34 1992
>
>SQL> select to_char(sysdate,'DD-MON-YY hh24:mm:ss') from dual ;
>............... Hit Return ................
>
>TO_CHAR(SYSDATE,'DD-MON-YYHH24:MM:SS')
>---------------------------------------------------------------------------
>07-AUG-92 08:08:50
>
>SQL> exit
>Disconnected from ORACLE RDBMS V6.0.33.1.1, transaction processing option - Production
>PL/SQL V1.0.32.3.1 - Production
>artemis% exit
>artemis%
>script done on Fri Aug 7 08:35:56 1992
>
> How do I set the correct time into sysdate? Any info/help on this
> is appreciated. Muchos Gracias.
>
> Ramesh S Rao ::::: hp-sdd!artecon!ram :::::
> 619/931-5500 ::::: ram%artecon_at_hp-sdd.sdd.hp.com ::::: (T)
> 619/931-5527 ::::: ram%artecon_at_sdd.hp.com ::::: (F)
I find similar behavior with the DOS version (6.0.33.?) It seems that the "mm" factor is stuck on "08". The seconds tick by, but the minutes are fixed (day, hours also seem ok). The time on the banner going into SQL*Plus is also ok, as is that shown by Mr. Rao.
Marvin Beck Iowa State University Received on Mon Aug 10 1992 - 17:13:18 CEST