SQL updating field with current timestamp

MS SQL to update a field to current time:

update tbl1 set col1 = convert(varchar(5),getdate() ,108)

result:

col1 13:05

You must be logged in to post a comment.