*Time in SYSDATE out of sync*

From: <ram%artecon_at_hp-sdd.sdd.hp.com>
Date: 8 Aug 1992 17:45:36 -0500
Message-ID: <9208071553.AA07755_at_artecon>

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) 


=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*

Received on Sun Aug 09 1992 - 00:45:36 CEST