Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out the current time zone in Oracle?
Kewl, both those work in 8.1.6 also. This could make new_date useful.
"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message
news:CWOj7.8$aG6.1403_at_inet16.us.oracle.com...
> FYI, this functionality is also available in 9i, where the database can be
> created in a specific timezone and sessions can be in their own client
> timezone using an ALTER SESSION command. To see the database timezone,
you
> simply SELECT dbtimezone FROM DUAL (like the old SELECT sysdate FROM DUAL)
> and to see the client timezone, you SELECT sessiontimezone FROM DUAL.
>
> I don't think this would be enough to make you upgrade to 9i, but it's
worth
> knowing anyway! ;)
>
> --
> HTH. Additions and corrections welcome.
>
> Pete
> Author of "Oracle8i: Architecture and Administration Exam Cram"
> Now got a life back again that the book is released!
>
> "Controlling developers is like herding cats."
> Kevin Loney, Oracle DBA Handbook
>
> "Oh no, it's not. It's much harder than that!"
> Bruce Pihlamae, long-term Oracle DBA
Received on Fri Aug 31 2001 - 13:11:25 CDT