Daylight savings calculation

vik1979 · Post by **vik1979** » Thu Aug 28, 2014 9:08 am

Hello All,

I would like to know if there is any function in datastage which can identify whether the given date come under daylight savings or not.
I am currently building a routine for it, but please let me know if there is any other approach to do it.

Thanks in advance!

chulett · Post by **chulett** » Thu Aug 28, 2014 10:07 am

There isn't.

Oh, and... good luck with that. I know it's not exactly 'on topic' but I found it amusing.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 28, 2014 12:58 pm

Not in DataStage, but you can probably interrogate the timezone environment variable (usually TZ).

vik1979 · Post by **vik1979** » Thu Aug 28, 2014 5:21 pm

Thank you Ray and Craig for the quick response ! I will do some research on the TZ.

vinothkumar · Post by **vinothkumar** » Mon Sep 01, 2014 2:07 am

Please remember that DST start date and end date differs for each year.
Also DST is defined till 2019 till now.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 01, 2014 2:38 am

Not in all countries it's not.

For example in Australia (a) it varies state by state and (b) it's a political decision.