Re: *Time in SYSDATE out of sync*

You are going to feel very stupid in just a moment.

  HH:MM:SS says "Hour:Month:Second"

Try using

  HH:MI:SS "Hour:MInute:Second"

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
>Copyright (c) Oracle Corporation 1979, 1989. All rights reserved.
>Enter user-name:
>Connected to:
>ORACLE RDBMS V6.0.33.1.1, transaction processing option - Production
>PL/SQL V1.0.32.3.1 - Production
>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.
>ps
> ORACLE RDBMS V6.0.33.1.1, PL/SQL V1.0.32.3.1
> 670MP running SunOS 4.1.2
>--
>=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
> Dont trust the "From" address above. Use any of the following:
>=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*
> 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)
>=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*

-- 
Andrew Finkenstadt       | Vista-Chrome, Inc.   |           andy_at_GEnie
GEnie Unix Sysop/Manager | The Printing House   |    NIC Handle: AF136
+1 904 222 2639 home     | 1600 Capital Cir SW  |   ...!uunet!rde!andy
+1 904 575 0189 work     | Tallahassee FL 32310 | andy_at_vistachrome.com