Post reply

TimeZone Implementation in DB or Application side?

  • August 6, 2011 at 4:37 am

    #245751

    Hello,

    We want to implement the timezone functionality through out the application.

    Here, the data fields will be saved in the DB in UTC date format and when you present those fields in the application they should be converted into the actual timezone.

    Here one more constraint should be taken... Day light Saving Time should be updated as per the current DST timings. (How to achieve DST from DB side)

    Here my question is, which is the better way to implement this functionality through out the application?

    from Database side or application side?

    Please Suggest 🙂

    Regards

    Ganesh Kumar

    GaNeSH

  • August 6, 2011 at 4:56 am

    #1364758

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1155514-338-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply