DateTimeOffset.Now in T-SQL

user_129347 0
Viewed 36527

I'm executing a INSERT to a sql 2008 db. How do I specify in T-SQL to insert NOW in a DATETIMEOFFSET column? GETDATE()?

datetime sql-server-2008 tsql sql-server sql
1 Answers

Maybe.

This would give you the local time of the server where SQL is installed.

Do you want to store timezone etc too? If so, SYSDATETIMEOFFSET() may be better

user_275350
Related