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
njsokalski@hotm ail.com

https://www.nathansokalski.com

[Mark D Powell]

Re: Using the NEW_TIME function

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

Nathan Sokalski wrote:
[color=blue]
> 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.[/color]

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]

Re: Using the NEW_TIME function


"Nathan Sokalski" <njsokalski@ver izon.net> schrieb im Newsbeitrag news:Jx47d.4410 $6f.1335@trndny 02...[color=blue]
> 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.[/color]
Fife minutes lookup in the doc gave me page 2-26 of the "Oracle9i SQL Reference".

Greetings!
Volker