TimeZone

sdharu · Post by **sdharu** » Mon Oct 30, 2006 7:46 am

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.

DSguru2B · Post by **DSguru2B** » Mon Oct 30, 2006 8:11 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Oct 30, 2006 9:14 am

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?