All Forums Database
BalaChuppala 3 posts Joined 10/12
23 Apr 2015
Converting CET TO PST timestamp

Hello Experts
I have a requirement to convert oracle date field, that YYYY-MM-DD HH:MM:SS , which is in CET TIME ZONE data.
This data to be  converted  to PST  Timezone in Teradata by considering the Daylight Saving Timings in mind.
Is there any  easier and more effecient way to tackle this issue.

Fred 1096 posts Joined 08/04
28 Apr 2015

Depends partly on how your system is set up.
If dbscontrol TimeDateWZControl is 3 or 4, then the job that loads the data should SET TIME ZONE = 'Europe Central' and the SELECT can specify or default to AT 'America Pacific'.
Consider storing the time zone (e.g. TIMESTAMP(0) WITH TIME ZONE) so you also have the option of displaying timestamp AT SOURCE in queries as well as AT LOCAL or AT (specific zone or fixed offset).

You must sign in to leave a comment.