on 11-25-2015 12:46 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.