SQL updating field with current timestamp

By peshvari, on March 10th, 2009

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.