UTC Offset

[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

[ray.wurlod]

Inspect the value of the TZ environment variable.

[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

[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.