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 -> Purpose of TZ_OFFSET()

Purpose of TZ_OFFSET()

From: ss <sk_at_microsoft.com.us>
Date: Sat, 29 Jan 2005 18:48:33 +0800
Message-ID: <41fb6a01$1_2@rain.i-cable.com>


What is the purpose of TZ_OFFSET()? For example,

select TZ_OFFSET('-3:0') from dual;
select TZ_OFFSET(sessiontimezone) from dual;
select TZ_OFFSET(dbtimezone) from dual;

just return their arguments. So what is the purpose of this function? If the only meaning is the to turn timezone name into offset value, then only the form TZ_OFFSET('time_zone_name') should be allowed but not the above 3 variants.

Also, the documentation said the return value dependent of the date the statement is executed, but why? Is it caused by daylight saving? Received on Sat Jan 29 2005 - 04:48:33 CST

Original text of this message

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