Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: TO_TIMESTAMP_TZ and unix timestamps
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
Received on Thu Jan 27 2005 - 14:58:10 CST