TimeZone Implementation For a SaaS

Asked Aug 23 '17 at 10:36

Active Aug 23 '17 at 10:36

Viewed 178 times

I am working on a SaaS product where the data has to be loaded to the consumer (End User) based on the producers (Client) time availablity, unfortunately the time availability of the producers are not stored in UTC, So I have tried the following technique to fetch the records,

--@offSet = '+05:30'
Select * From ProducerAvailablitiy
Where producerTimeSlot is 
between Cast(switchoffset(GETUTCDATE(),@offSet)  As datetime) and Cast(switchoffset(GETUTCDATE(),@offSet) + 1

I have a table with list of timezone offset, which are refrenced to the producer (Client) this seems to be working properly as of now. But I read this article. According to it single timezone can have multiple offset (Daylight savings) so I just want to know how to tackle this situation.

asked Aug 23 '17 at 10:36

Gokulan P H

1,838
1
10
13

1

(See [my answer](https://stackoverflow.com/a/40388919/634824) in the dup link) – Matt Johnson-Pint Aug 23 '17 at 18:41
will it handle daylight savings offset variance? – Gokulan P H Aug 24 '17 at 12:20
Yes, that's the point. – Matt Johnson-Pint Aug 24 '17 at 14:52
@MattJohnson I have implemented the following suggestion, it seemed to be working fine till then but now when we are checking for Alaskan Standard Time 'AT TIME ZONE' gives -08:00 where as it should be -09:00 now. DST: Mar 12, 2017 - Nov, 05 2017 – Gokulan P H Oct 24 '17 at 15:35
Today is only October 24th. DST is still in effect, so -8 is correct. It will go back to -9 at 2:00 am on November 5th. See: https://www.timeanddate.com/time/zone/usa/anchorage – Matt Johnson-Pint Oct 24 '17 at 18:28

TimeZone Implementation For a SaaS

0 Answers0