Post reply

Change time zone!!!

  • September 1, 2004 at 3:46 pm

    #89135

    Does anyone know how to change the time zone reference?

    I have several queries that use the getdate() function.  I am in Arizona and it writes to the database as 1 hour ahead of realtime here.....

    Anyone know if or how I can fix this?

    Kristin

     

     

    Kristin

  • September 2, 2004 at 2:31 am

    #521465

    Hi,

    SQL Server gets its time zone from the operating system. On the server go to control panel and choose Date and Time settings. There is a tab called Time Zone. You can change it there.

     

     


    Andy.

  • September 2, 2004 at 7:03 am

    #521497

    ah hah!  I was trying to make it more difficult than it was  thanks!

    Kristin

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

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