Using the NEW_TIME function

[Nathan Sokalski]

I am trying to use the NEW_TIME function in ORACLE, but do not know all of
the time zone codes for all of the necessary locations. The specific
location that I do not know and need to know is the time zone code for
London's time zone. However, I would like to know the other valid time zone
codes so I know what codes Oracle accepts as time zones. I could not find
this information on Oracle's site or anywhere else on the Web. Any help
would be appreciated. Thanks.
--
Nathan Sokalski
nj********@hotmail.com
www.nathansokalski.com

[Mark D Powell]

**** Post for FREE via your newsreader at post.usenet.com ****

Nathan Sokalski wrote:

I am trying to use the NEW_TIME function in ORACLE, but do not know all of
the time zone codes for all of the necessary locations. The specific
location that I do not know and need to know is the time zone code for
London's time zone. However, I would like to know the other valid time zone
codes so I know what codes Oracle accepts as time zones. I could not find
this information on Oracle's site or anywhere else on the Web. Any help
would be appreciated. Thanks.

I am not at work so I cannot play with the function, but London is UTC
which is the newer name for GMT (Greenich Mean Time). Perhaps this will
help.

-- Mark D Powell --

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

[Volker Hetzer]

"Nathan Sokalski" <nj********@verizon.net> schrieb im Newsbeitrag news:Jx47d.4410$6f.1335@trndny02...

I am trying to use the NEW_TIME function in ORACLE, but do not know all of
the time zone codes for all of the necessary locations. The specific
location that I do not know and need to know is the time zone code for
London's time zone. However, I would like to know the other valid time zone
codes so I know what codes Oracle accepts as time zones. I could not find
this information on Oracle's site or anywhere else on the Web. Any help
would be appreciated. Thanks.

Fife minutes lookup in the doc gave me page 2-26 of the "Oracle9i SQL Reference".

Greetings!
Volker