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 |
|
naiade lima
Starting Member
2 Posts |
 Posted - 2013-10-04 : 14:58:58
|
| Hello,Does anyone know how to update the time of sql server?Because when I use the command GETDATE() , the time is wrong.Thank you very much. Yours sincerely Naiade Lima. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-10-04 : 15:17:35
|
| You would update the computer's date/time settings as SQL Server uses that. Bottom right hard corner on the desktop...Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-04 : 15:18:15
|
| It is returning the timestamp of the system where the database server is running.So if you are in Rio de Janeiro and your database server is in New York, you would see the timestamp to be one hour behind (or something like that). |
|
|
|
naiade lima
Starting Member
2 Posts |
Posted - 2013-10-04 : 15:45:49
|
| Well, I did a little research and discovered it actually the SQl Server is unique which the time can't be configured, because it use the time of system, different from Oracle, Postgres [...], which can be configured.Thanks very much for the answers.Ass,Naiade Lima |
|
|
|
|
|
|
Time of SQL Server 2008