Page 1 of 1
UTC Offset
Posted: Fri Dec 10, 2010 1:31 am
by satheesh_color
Hi All,
can anyone share your ideas on how to generate the UTC offset value from the transformation stage.
Standard timezone offset from UTC [-12,14]
Thanks,
Satheesh
Posted: Fri Dec 10, 2010 3:35 am
by ray.wurlod
Inspect the value of the TZ environment variable.
Posted: Wed Dec 15, 2010 7:39 am
by satheesh_color
Hi Ray,
plslc000:>echo $TZ
CST6CDT
My source table has a field time_zone contains the value of (E,C,P,M) for Eastern,Central,Pacific and Mountain.Please advice me how to find the UPC offset for the timezones EST,CST,PST,MST.
Thanks,
Satheesh
Posted: Wed Dec 15, 2010 4:57 pm
by ray.wurlod
The 6 in $TZ indicates UTC+6. The CDT part flags daylight saving (summer) time offset is in use.
You can readily map ECMP tp 5678 using a Convert() function, but you still need to be aware of whether or not daylight saving offset is in effect.