470,613 Members | 2,186 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

Using the NEW_TIME function

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
Jul 19 '05 #1
2 5726
**** 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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Jul 19 '05 #2

"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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

28 posts views Thread by Daniel | last post: by
3 posts views Thread by Random Person | last post: by
1 post views Thread by Daveyk0 | last post: by
3 posts views Thread by Rob | last post: by
14 posts views Thread by B Williams | last post: by
2 posts views Thread by Nathan Sokalski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.