DateTimeOffset.Now in T-SQL

datetime, sql, sql-server, sql-server-2008, t-sql

Solution

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

Problem

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()?

Original source