Re: SYSDATE - Time slow to update?

From: David & Kim Di Biaggio <dibiaggio_at_iquest.net>
Date: 1996/09/05
Message-ID: <322EF3AD.244_at_iquest.net>#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

I had to laugh when I saw this, I did the same thing once and went crazy trying to figure out my problem.... your format string should read MI for minutes, not MM (which is months). Good luck! Received on Thu Sep 05 1996 - 00:00:00 CEST

Original text of this message