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

    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.


  2. #2
    Join Date
    Dec 2002
    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
    San Antonio, TX
    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