CONVERT(VARCHAR(8),GETDATE(),108)
Result
14:12:30

Other examples
print convert(varchar(30),getdate(),121)
— Result: 2011-05-09 12:04:31.883
print convert(varchar(30),getdate(),113)
— Result: 29 Apr 2011 13:41:23:327

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.