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.

Did you really feel compelled to post to every usenet group you could spell without reading any of the FAQs or rules?

A demo of NEW_TIME can be found at http://www.psoug.org Click on Morgan's Library
Click on Date Functions.

Click on the link at the bottom of the page for Timestamp and you will find information on time zones.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)