Re: SYSDATE

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 12 Oct 2005 02:10:45 -0700
Message-ID: <1129108245.085259.234590@g44g2000cwa.googlegroups.com>

JBB, the sysdate function is dependent on database nls settings. You can set the database time zone to be different from the OS time zone setting. The current_date function is dependend on client nls settings.

Oracle provides a function to change a date/time value to a different time zone: new_time.

select

to_char(sysdate,'YYYYMMDD HH24:MI:SS') as "Eastern Daylight" ,to_char(new_time(sysdate,'EDT','GMT'),'YYYYMMDD HH24:MI:SS') GMT from sys.dual

Depending on what you need to do this might be useful to you.

HTH -- Mark D Powell -- Received on Wed Oct 12 2005 - 04:10:45 CDT