Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: sysdate problems
What we have here is a basic failure to communicate. Look again at your syntax, and think really, really hard. Oh, all right, a giveaway. Wait three more weeks, this query will return 11:06. I guarantee it.
"Sonja Barton" <sbarton_at_starband.net> wrote in message
news:XFZL6.47$ph3.35200029_at_twister2.starband.net...
> I use sysdate to insert the current date/time into a field in a table. I
> also use it in a log file heading.
>
> Using ALTER SESSION SET NLS_DATE_FORMAT = 'mm/dd/yyyy hh:mm:ss';
> ignores me and uses the dd-mon-yyyy format when I add the hh:mm:ss. Just
> setting the format to 'hh:mm" returns the time properly (almost - read
on).
>
> using to_char(sysdate, 'mm/dd/yyyy hh:mm:ss') works (almost - read on).
>
> However, no matter which form I use, sysdate always returns a time 5
minutes
> after the hour. 11:59 is reported as 11:05. 11:01 is reported as 11:05.
>
> Has anyone seen this before? If so, I surely appreciate a fix for it!
>
> Thanks,
> Sonja
>
>
Received on Mon May 14 2001 - 21:20:54 CDT