Re: SYSDATE - Time slow to update?
From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1996/09/04
Message-ID: <50kadk$sks_at_zimmer.CSUFresno.EDU>#1/1
Date: 1996/09/04
Message-ID: <50kadk$sks_at_zimmer.CSUFresno.EDU>#1/1
In article <322c6449.13103797_at_news.sound.net>,
Cary Coulter <cwc_at_sound.net> wrote:
>I am using SYSDATE like:
>
> TO_CHAR ( SYSDATE, ''Month DD, YYYY HH:MM AM')
Try using MI instead of MM where you want minutes. MM will give you the MONTH! (This has got to be Oracle's best 'Gotcha' ever).
Steve Cosner
>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.
Received on Wed Sep 04 1996 - 00:00:00 CEST