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
UTC Offset
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.