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

,Zephyr <p.neumann (AT) ids-scheer (DOT) 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)

Zephyr wrote:
Change 'HH24:MM' to 'HH24:MI' - you've got MONTHS where you want MINUTES )


Cheers,
Norm.

Sorry for this newby question, I need to go home or some holidays ;-)