Home > IT Answers > Development > How to get local time of a SQL server?
Edchu
5 pts.
 How to get local time of a SQL server?
C#, SQL, SQL Server
Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

Software/Hardware used:
ASKED: August 27, 2008  8:03 AM
UPDATED: August 27, 2008  1:58 PM
RELATED QUESTIONS
Answer Wiki:
You can get the local time of the SQL Server by using the getdate() system function. <pre>SELECT getdate()</pre> If you want to get UTC time use the getutcdate() system function. <pre>SELECT getutcdate()</pre>
Last Wiki Answer Submitted:  August 27, 2008  8:15 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,505 pts.