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 -> Time

Time

From: Zephyr <p.neumann_at_ids-scheer.de>
Date: Wed, 16 Feb 2005 11:03:28 +0100
Message-ID: <42131acb$0$5316$4d4ebb8e@read-nat.news.de.uu.net>


Hi,

I'am facing a strange behaviour of my ORACLE 9.2.0.4 server. I always get the same time back from

select to_char(sysdate, ('DD.MM.YYYY HH24:MM')) ActualTime from dual;

ACTUALTIME



16.02.2005 10:02

I added seconds output to the query and the secondes will be counted correctly,
but after the time 10:02:59, the time will be return to 10:02:00. After an hour the
time will be set to 11:02.

The Parameter fixed_date has o value.

Any ideas how to get the time working again?

Thanks
Patrick Received on Wed Feb 16 2005 - 04:03:28 CST

Original text of this message

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