TO_TIMESTAMP_TZ and unix timestamps

[supermega]

hmmm... i see your point about doing the math after the timestamp conversion. i was doing it there because someone else tested it and found that if you did math in it the procedure returned a date instead of timestamp and the DST wasnt taken into account. my next guess would be do the math in a to_date and assign that to a variable and pass that variable to a to_timestamp_tz.

what i am hoping is if i pass Apr 04 2005 09:00 to a to_timestamp_tz oracle would return the time being 08:00 because it the date is in daylight daving time.

Thanks in advance,
--SM