Re: SYSDATE - Time slow to update?

cwc_at_sound.net (Cary Coulter) writes:

>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.
<< posting cut here, will continue at bottom... >>

Cary,

You want to have:

TO_CHAR ( SYSDATE, 'Month DD, YYYY HH:MI AM')

Note that 'MM' is the month in a 01=JAN 02=FEB 03=MAR, etc format. 'MI' is the correct format for Minute.
The reason that the time wasn't changing was that what you thought was a MINUTE was the MONTH.

Hope this solves the problem.

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: http://homepage.interaccess.com/~akaplan   <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

<<the rest of the post follows...>>

>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
Received on Tue Sep 03 1996 - 00:00:00 CEST