Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using the NEW_TIME function

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@www.orafaq.net>

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.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Fri Oct 01 2004 - 08:17:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US