Deriving Date based on given Time zone

[koolnitz]

Hello All

I have a requirement to find out current date for a country by having it's Time zone info. Am trying to explain my requirement through the following example..

DS server has been installed in Hong Kong and I need to find out current date in India. I'm thinking to introduce two parameters (e.g. prmServerTimeZone=+8 and prmCountryTimeZone=+5.5 , indicates that HK is GMT+8 and India is GMT+5.5). Parameters are appreciated for the case we deploy the project elsewhere.


Can someone please help me to find out the current date for India using DataStage? I'm asked not to bother about Daylight saving.

Suggestion about any better approach would be appreciated.

Thanks in advance!

[chulett]

Assuming you have the parameters you've shown? Adjust the time by the difference in them: -2.5 hours in your example.

[koolnitz]

Hi Craig,

I'm unable to find a way to subtract hours from Date
Suppose, if the current timestamp of server is 2007-11-14-01.09.50.384917, then the desired output should be a Date field with value 2007-11-13, for the given example.

Thanks!

[chulett]

Sorry, I'm not familiar enough with the date/time functions in PX to give anything other than high-level advice.

So, you don't need to figure out the time difference, just if the timezone change affected the date or not? Make sure your requirement is clear, then others can give you specific help with the functions.

[koolnitz]

Sorry if I was unable to express my requirement clearly.

Yes, I don't need to figure out the time difference. I just want capture the current date of a country with the help of it's given timezone (GMT+/-n).

[koolnitz]

Following derivation logic works when used in Transformer:

TimestampToDate(TimestampFromSecondsSince(-(GetEnvironment('prmServerTimeZone')-GetEnvironment('prmCountryTimeZone'))*3600, CurrentTimestamp()))

Forgot to mention that the given parameters have been defined as Environment variables, hence used GetEnvironment() function.