wanted to keep diffrent timzone database on same sqlserver instence. RRS feed

  • Question

  • hi,

       i wanted to keep more than one database on same instence of sqlserver,

    each database can have diffrent timezone datetime as data.

    q1) In how many ways i can accomplish the task, the consideration is in stored procedure or .net if i  get the current time it will get the current OS time so for manipulation i have to use some offset.

    so before implementation, i want to know that how many ways, i can accomplish the task and which one will be fisible.

    Q2 entry module can be on other OS with diffrent timezone it can also also have a

    database whoes data will be mearged with above said instance which will have more than one databases with different time zone dates as a data.

    yours sincerely

    Tuesday, July 22, 2014 3:33 PM


  • I suggest you post on the SQL Server forum


    • Marked as answer by rajemessage Wednesday, September 10, 2014 7:37 AM
    Wednesday, July 23, 2014 8:08 AM