sysdate problems

From: Sonja Barton <sbarton_at_starband.net>
Date: Mon, 14 May 2001 23:15:03 GMT
Message-ID: <XFZL6.47$ph3.35200029@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 - 18:15:03 CDT