Please, read comments to the question. You did not provide enough information about issue and the reason you want to update
field every second. Nevertheless...
You really don't need this!
To get SQL server time, see: Date and Time Data Types and Functions (Transact-SQL)
SELECT GETDATE(), SYSDATETIME(), SYSUTCDATETIME(), GETUTCDATE()