DSXchange

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

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.