Click here to Skip to main content
16,016,562 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a server in USA.My application is running on the server and for that i needs the timezone to be set IST in the server. How can i change the server time to IST? The application is running Windows 2012 server.
Posted

1 solution

Quote:
SQL defers to the OS for knowing date, time and timezone. You can't set it within SQL Server.

source: http://www.sqlservercentral.com/Forums/Topic543254-149-1.aspx#bm543426[^]

Many useful information you'll find here: TimeZone Offsets With Sql Server[^].
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900