cwc@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: www.arikaplan.com <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<>
>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
Back to Ari Kaplan's Home Page