Page 1 of 1

Daylight savings calculation

Posted: Thu Aug 28, 2014 9:08 am
by vik1979
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!

Posted: Thu Aug 28, 2014 10:07 am
by chulett
There isn't.

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

Posted: Thu Aug 28, 2014 12:58 pm
by ray.wurlod
Not in DataStage, but you can probably interrogate the timezone environment variable (usually TZ).

Posted: Thu Aug 28, 2014 5:21 pm
by vik1979
Thank you Ray and Craig for the quick response ! I will do some research on the TZ.

Posted: Mon Sep 01, 2014 2:07 am
by vinothkumar
Please remember that DST start date and end date differs for each year.
Also DST is defined till 2019 till now.

Posted: Mon Sep 01, 2014 2:38 am
by ray.wurlod
Not in all countries it's not.

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