Re: NLS_DATE_FORMAT with GMT postfix

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 27 Nov 2001 09:15:35 -0800
Message-ID: <9u0hnn02u31@drn.newsguy.com>

In article <3c03a855_at_dnews.tpgi.com.au>, "Chris says...
>
>I would love a resolution of this issue. I am currently designing an
>application that must support multiple time zones.
>
>First let me say that in the views xxx_TAB_COLUMNS there are data types
>TIME, TIMESTAMP and INTERVAL. I cannot find anything on these in the 8.1.5
>SQL doco. Assuming these types are NOT available and we are stuck with the
>regular Oracle DATE then read on.
>

Oracle9i provides full support for dates with timezones, has the concept of a server timezone, client timezone and intervals.

[snip]

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Tue Nov 27 2001 - 11:15:35 CST