cancel
Showing results for 
Search instead for 
Did you mean: 

Change in time due to daylight saving

Former Member
0 Kudos

In a SAP BODS job, we are calling a function to change integer time to datetime format. However there is one more requirement along with this. We have to come up with a logic inside the same function to check whether the resultant time falls under the daylight saving period and accordingly update the time to +/- 1 hour.

We have a Date dimension table containing records for a span of 25 years(which includes past, present and future dates) which we are planning to utilize.

Any kinds of input/ideas would be helpful. TIA.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

You have to write a function in SQL Server that returns a UTC time. This has to be captured in a variable and used in your transform.