Select = Case When Between UTC_DST_Start And UTC_DST_End Then -5 Else -6 End Next, I would create a function to take a DATE in UTC and return the value in either CST or CDT, depending on the time of the year. This will generate the DST times from the year 2000 to 2067 (this can be expanded based on your needs). all the years from 2000 through 50 years after the current year: The linked answer ( Sql Server Specify time in another timezone) will get you most of the way there, but to answer the rest of your question, you'll have to make some modifications.įirstly, I would create a DST calendar, since the DST start and end dates are something that we can compute: CREATE TABLE dbo.TZCalendar The logic seems right for me, but, I just need a function without SCHEMABINDING (which is done in the reference link). Is there a way to automatically change to -5 during daylight saving time and -6 during standard time?Īfter looking at the Answer and the reference link from #Siyual,I created the dbo.TZCalendar table and I tried to create a function like this (takes one argument and returns a date from refrence link) CREATE FUNCTION DATETIME Return this still gives me the same result as above.ġ. The Central Time Zone, includes that part of the United States that is west of the boundary line between the eastern and central standard time zones ( view) and east of the boundary line between the central and mountain standard time zones described ( view ). RETURNS datetime, - Second Sunday in datetime - First Sunday in November So, I changed Smith's function like this, CREATE FUNCTION int
Since we are in Day Light Saving time, I am using 5 as my offset. I input both like this, SELECT dbo.fn_UTC_to_DST(,5) as Date In that function, it needs two arguments such as UTC time and offset. I tried to use the function from Smith's answer, which is. I have a UTC time column and I want convert to into current local time (Central Time Zone or America/Chicago). This question is a follow up from this question.
0 kommentar(er)
