April 15, 2012 at 7:51 am
Hello,
I wish to have one of my date columns to adjust with dst and utc and populate in computed columns. For ex: during dst the date col has to be pushed back to 6 hrs else 5 hrs.
set @timediff = datediff(hh, col1, getutcdate()) this col1 is from table
select col1, (computed col) col2 = case (@timediff)
case '5' then col1 date is pushed back 5 hrs
case '6' then col1 date is pushed back 6 hrs
from table
Any help appreciated?
April 15, 2012 at 11:53 am
Ignor comment just re looked at your query, what exactly do you expect the reslult to be?
***The first step is always the hardest *******
April 15, 2012 at 12:14 pm
I dont think we can control DST/GMT times. You will have to take the help of CLR functions to do the adjustments.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply