DSXchange

We have a requirement where we need to convert the remote server time to local server time, taking daylight saving into consideration. can we use a routine by which date and year from the input can be extracted and same can be compared with the daylight saving dates? Or is there any other method to accomplish the same task.

Welcome aboard
Do you have the logic in your mind. If you do, you can put down the psuedocode here and someone can help you build a routine.
You can get the Year and month both by using ICONV/OCONV functions. Look into help.
Need more info on what do you mean by "convert the remote server time to local server time"
You can get the current time in datastage by using the DATE() function. You can manipulate it further.
Regards

You can also get at the TZ environment variable or specify "DZ" in an Oconv() to get the time zone for the DataStage server machine. How do you propose to get the remote server time and time zone? A database query perhaps?