Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Purpose of TZ_OFFSET()

Re: Purpose of TZ_OFFSET()

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 31 Jan 2005 08:04:44 -0800
Message-ID: <1107183633.326682.168100@c13g2000cwb.googlegroups.com>


The purpose of tz_offset is to return the time zone offset of the entered value from UTC (formerly GMT) for the value entered. It accepts three forms of input one of which happens to be the time zone offset to begin with so it simply returns the value. The function can be useful when working with timestamps from different local time zones. The value returned by the function is affected by DST so the value returned for a specific locale may change based on the date. HTH -- Mark D Powell -- Received on Mon Jan 31 2005 - 10:04:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US