Thursday, August 1, 2013

To get current time in 24 hour format


Query
SELECT CONVERT(VARCHAR(20), GETDATE(),108)
Result
14:47:34

No comments:

Post a Comment