Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    4

    Unanswered: Set SQL Server To a different TimeZone?

    Can you set sql server to use a different timezone that the one set in the regional settings (system time)? If so can someone can you please explain how.

    Varun

  2. #2
    Join Date
    Dec 2002
    Posts
    63
    SQL Server time is based on the system time kept by the bios of the server. To make it appear as though it is in a different timezone, you will need to create a function or do some datemath when you select insert and update any dates.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I'll probably blur it out again too soon, but I don't think you can make SQL Server return anything other than the data/time of the OS it runs on (regardless of whether it is a stand-alone server of a DC) when doing SELECT GETDATE() or SELECT CURRENT_TIMESTAMP. Information on all system-related resources is available to SQL Server ONLY through registry entries and/or Windows API calls. In the case of date/time you won't see anything different unless you manage to alter the corresponding DLL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •