Re: timezone

Paul,

I must disagree. The original poster asked how to know programatically what value should be used in a NEW_TIME() oracle function. NEW_TIME only accepts AST?ADT (atlantic),BST/BDT (bering), CST/CDT (central), EST/EDT (eastern), GMT (greenwich), HST/HDT (alaska-hawaii), MST/MDT (mountain), NST (newfoundland), PST/PDT (pacific) and YST/YDT (yukon) according to my SQL manual. Since that narrows the scope to Western hemisphere, the output from a formatted "date" command would work.

What DO the folks in the Eastern hemisphere use for the "local" timezone values instead of the list above?

Mike

++++++++++++++++++++++++++++++++++++++++++++++++++++

Paul Eggert <eggert_at_twinsun.com> wrote in article <5tstc1$89i$1_at_tattoo.twinsun.com>...
| "Mike Morgan" <mmorga2_at_amfam.com> writes:
|
| >TZ=`date +"%Z"`
| >Then you can use ${TZ} in sqlplus :
|
| I wouldn't recommend that. The output of `date +%Z' isn't suitable
| as an input value for the TZ environment variable. And in applications
| deployed worldwide, a string like `EST' isn't suitable for a time zone
| designation, since it means something different in Australia than it
| does in the USA.
|
Received on Mon Aug 25 1997 - 00:00:00 CDT