Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using the NEW_TIME function
That is definitely a nice site, and in many cases I would say it was very
useful, but in this case it was no more useful than any of the other sites I
found. I already know how to use the NEW_TIME function, I simply need a list
of the valid time zone codes. The only place on the site that I saw any time
zone codes were when 'AST' and 'PST' were used in the example.
-- Nathan Sokalski njsokalski_at_hotmail.com www.nathansokalski.com "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1096675274.218122_at_yasure...Received on Fri Oct 01 2004 - 22:33:51 CDT
> 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)
>