Kristin Stariha
Ten Centuries
Points: 1012
More actions
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
jordanac
Hall of Fame
Points: 3653
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!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply