Re: SYSDATE - Time slow to update?

From: Alexey E. Neckrasow <nec_at_leaves.spb.su>
Date: 1996/09/04
Message-ID: <322D2EE2.4E1A_at_leaves.spb.su>#1/1


Cary Coulter wrote:
>
> I am using SYSDATE like:
>
> TO_CHAR ( SYSDATE, ''Month DD, YYYY HH:MM AM')
>
> to format a date/time string. The time doesn't update as it should.
> The time may be over an hour old at times.
>
> We are using Forms 4.5. It doesn't seem to have anything to do with
> the time Forms was loaded, exiting all Oracle applications on the
> workstation (Win95) and re-loading them doesn't always change the
> date. The server is on NT 3.51.
>
> Anybody seen anything like this?? Any ideas??
>
> TIA
> Cary

Hi, Cary!

There is the error in format mask:
MM means month number and
MI means minutes (0-59)

-- 
Regards. Alexey Neckrasow. Leaves Inc. Russia.
Received on Wed Sep 04 1996 - 00:00:00 CEST

Original text of this message