Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinoth86
Starting Member
27 Posts |
 Posted - 2008-04-24 : 00:14:38
|
| Hi, We using SQL SERVER2000..and in control panel we enabled date/time settings as per IST.I updated one record at 9.30...It shows time 4.It's showing GMT time,how to change the time format.I used UTC function to get timing.Plz help me ASAP. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-24 : 00:18:17
|
| Use GETDATE() instead of GETUTCDATE() if you don't want GMT.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
How to change the time property in sql server 200?