Is there a function or method to determine Daylight versus Standard time?
I know that the first Sunday of April and last Sunday of October is DST but I can't find a function to determine this. Has anyone developed some built-in functions?
As well, is there a function to convert EST to GMT? I can see the GMT function, but it only change current system time to GMT.
Thanks in advance
GMT and Time Zone
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard! :D
There are a few ways that this can be accomplished. One of the difficulties with daylight saving (summer) time is that it can be different in different locations - for example in the southern hemisphere summer is at the other end of the year compared to the northern hemisphere.
Check through the Transforms and Routines in the SDK to get some ideas, and read about the SYSTEM() function in the DataStage BASIC manual.
There are a few ways that this can be accomplished. One of the difficulties with daylight saving (summer) time is that it can be different in different locations - for example in the southern hemisphere summer is at the other end of the year compared to the northern hemisphere.
Check through the Transforms and Routines in the SDK to get some ideas, and read about the SYSTEM() function in the DataStage BASIC manual.
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.