Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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
38200 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

3873 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  
 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.11 seconds. Powered By: Snitz Forums 2000