Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Time zone considerations Expand / Collapse
Posted Wednesday, May 22, 2013 10:51 AM

Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 5:16 AM
Points: 3,077, Visits: 765
Hi Jessica and readers,

I have an international/multiple time zone client base, do you have recommendations for selecting time zones, and delivering reports to clients respective of their local time?

A client could select a zone other than their own for a given report at run time, however the time should initially default to the clients' local time.

It looks like System.core.dll has the time information - can it be loaded into a report parameter drop-down? Or, would it be smarter to use a SQL table and a query/sProc ?

With the fairly recent change in DST date, is there a reliable way to see if it is DST season or not for a given date?

All reporting data is stored with UTC time

The client time zone is identified, and UTC offset in minutes including DST

Thank you in advance for your answers and recommendations.

Tom in Sacramento

For better, quicker answers on T-SQL questions, click on the following...
Post #1455614
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse