Re: Time

From: <dhh_at_my.invalid>
Date: 16 Feb 2005 10:35:12 GMT
Message-ID: <cuv7l0$edc$1@news.liv.ac.uk>

,Zephyr <p.neumann_at_ids-scheer.de> wrote:
: 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;

                                             ^^   
                                             MI

: 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

HTH Helen (qq45 liverpool ac uk) Received on Wed Feb 16 2005 - 04:35:12 CST