SQL updating field with current timestampBy peshvari / March 10, 2009 MS SQL to update a field to current time: update tbl1 set col1 = convert(varchar(5),getdate() ,108) result: col1 13:05