Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using the NEW_TIME function
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.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=