How to get current time of SQL server?
-
Hi,
I create some tables in SQL server. I connect to these tables using a Qt program. Qt program run on a different PC from SQL server. I want to get time of the system which run SQL server management in the qt program. I have Date field in the tables but they are empty now. How can I initial them?
-
@lina Did you find any specific SQL query which returns time?
-
Hi
Do you mean like this ?
http://www.blackwasp.co.uk/SQLGetDate.aspxA Date field merely holds a date type. so unless you write to it from the client
nothing is shown.0Please use the Topic Tools button to mark as Solved and
Upvote the answer(s) that helped you to solve the issue
postimage.org can be used for screenshots.1 Replies
-
Hi,
yes, I use sql server management tool. the name of database is Doc and the table which has Date field named as archive.I'm new in sql server. where should I add the below code?
-- Select the current local time
**SELECT getdate()DECLARE @CurrentTime DATETIME
SET @CurrentTime = getdate()
PRINT @CurrentTime**
-
@lina
Hi
Its been some years since i used MS SQL so not sure about it.
Links says " SQL Server Management Studio query window. "2Please use the Topic Tools button to mark as Solved and
Upvote the answer(s) that helped you to solve the issue
postimage.org can be used for screenshots.
-
@mrjj
thanks, it works.
