Time zones handle in SQL Server 2012

Posted on 2012-09-10
Last Modified: 2012-10-31

Currently we’re using Merge Replication (Push and Pull) for our application.
We’ve our Publisher DB located at EST time zone. And all 53 subscribers were located in different time zones.
14 subscribers were located at EST time zone
23 subscribers were located at PST time zone
12 subscribers were located at MST time zone
4 subscribers were located at CST time zone

Now we’re planning to use centralized DB with “Always ON” feature in SQL Server 2012 for our application.
But we’re having problem because of different time zones. We would like to do minimal changes to our application to handle time zone.

My Plan: To update all the related tables with proper Date and time using Stored procedure and function as we’ve used Now statement at many places.
I don’t think Triggers is the best solution as I’ll need to update minimum 25 tables at a time. And 100 users will do the same transactions at the same time.

Can you please provide suitable solution for these scenario?
Question by:selfstoragemanager
    1 Comment
    LVL 25

    Accepted Solution

    Depending how minimal of a change you are looking for, you might want to consider the datetimeoffet data type:

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now