SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Time of SQL Server 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

naiade lima
Starting Member

Brazil
2 Posts

Posted - 10/04/2013 :  14:58:58  Show Profile  Reply with Quote
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

USA
37133 Posts

Posted - 10/04/2013 :  15:17:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
You would update the computer's date/time settings as SQL Server uses that. Bottom right hard corner on the desktop...

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3706 Posts

Posted - 10/04/2013 :  15:18:15  Show Profile  Reply with Quote
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).
Go to Top of Page

naiade lima
Starting Member

Brazil
2 Posts

Posted - 10/04/2013 :  15:45:49  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000