Skip to main content

All Questions

Filter by
Sorted by
Tagged with
14 votes
2 answers
10k views

Handling time zones in data mart/warehouse

We are starting to design the building blocks of a data mart/warehouse and we need to be able to support all time zones (our clients are from all over the world). From reading discussions online (and ...
Vesselin Obreshkov's user avatar
7 votes
1 answer
4k views

SQL Server 2012 equivalent of AT TIME ZONE capability

Is there a way in SQL Server 2012 to get what the server time zone would be on a particular date/time? In SQL Server 2016, you have AT TIME ZONE, but that's not available in 2012. I have a ...
Cade Roux's user avatar
  • 6,612
2 votes
2 answers
1k views

SQL Server and SharePoint time problem

I have created a SharePoint application which has a specific time zone. The Windows server where SQL Server and SharePoint are installed are using same time zone. When I create a new item in list ...
Frank Martin's user avatar