Re: TO_TIMESTAMP_TZ and unix timestamps

The poor cpu does not know, that is correct. The function TO_TIMESTAMP_TZ does however, does know based on your dbtimezone.

from
http://www.oracle.com/technology/products/oracle9i/htdocs/9iober2/obe9ir2/obe-nls/html/datetime/datetime.htm

"

Support for Daylight Saving Time
Daylight Saving Time (DST) is observed in the United States and its territories except Hawaii, American Samoa, Guam, Puerto Rico, the Virgin Islands, the Eastern Time Zone portion of the State of Indiana, and most of Arizona (with the exception of the Navajo Indian Reservation in Arizona). Oracle automatically determines, for any given time zone region in the United States, whether daylight saving time is in effect and returns local time values based accordingly. The datetime value is sufficient for Oracle to determine whether daylight saving time is in effect for a given region in all cases except boundary cases

TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE datatypes

If a TIME_ZONE REGION is associated with the datetime value then the Oracle server knows the Daylight Saving Time rules for the region and they will be considered in any operation with this datetime value. Daylight Saving Time is not calculated for regions that do not use DST
"

--SM Received on Wed Jan 26 2005 - 12:46:27 CST