Re: Using the NEW_TIME function

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 Oct 2004 08:17:42 -0500
Message-ID: <42b9e2f6054608c6b4b64a26ee8da1eb$1_at_www.orafaq.net>


  • 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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Fri Oct 01 2004 - 15:17:42 CEST

Original text of this message