Re: Time

From: Norman Dunbar <Norman_at_Dunbar-it.co.uk.REMOVETHIS>
Date: Wed, 16 Feb 2005 14:15:48 +0100
Message-ID: <cuvk9f$676$3$830fa79d@news.demon.co.uk>

Zephyr 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;
>
>
> 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
>
>

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

Cheers,
Norm. Received on Wed Feb 16 2005 - 07:15:48 CST