Re: TO_TIMESTAMP_TZ and unix timestamps

SuperMega wrote:

> thanks,
> I to am doing this for a cellular phone company, the dates are allready
> in the table ( in unix timestamp ) this company is only east coast ,
> all in the same tz. unix timstamps on count the seconds from a specific
> date in 1970 so when doing a todate if that time fell within DST it
> wouldnt minus the hour. corporate hq wants to see the time that it was
> when the unix timestamp was created and in this part of the country it
> is all the same tz. so i am using to_timestamp_tz which is supposed to
> automaticaly do a conversion for DST if yout dbtimezone is set to a tz
> that observes DST, which ours 'EST' does.
> I hope that explaines this a little better,
> thanks again,
> --SM

Keep in mind that TO_DATE and Timestamp do not mix: Think TO_TIMESTAMP.

Much of the syntax you want, with examples, is on the TIMESTAMP page in Morgan's Libary at http://www.psoug.org.

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)