peshvar.com

MS SQL to update a field to current time:

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

result:

col1 . . . → Read More: SQL updating field with current timestamp