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
MS SQL to update a field to current time: update tbl1 set col1 = convert(varchar(5),getdate() ,108) result: col1 13:05