Re: SYSDATE

From: Chris ( Val ) <chrisval_at_bigpond.com.au>
Date: 19 Oct 2005 18:58:06 -0700
Message-ID: <1129773486.723506.31750@g14g2000cwa.googlegroups.com>

Mark D Powell wrote:
> 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.

Nice answer Mark :-)

Cheers,
Chris Val Received on Wed Oct 19 2005 - 20:58:06 CDT