DateTimeOffset.Now in T-SQL

Question

I am performing an INSERT for db sql 2008. How do I tell T-SQL to insert NOW into the DATETIMEOFFSET column? GETDATE ()?

Answer 1

May be.

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

Do you want to save time zone, etc. also? If yes, SYSDATETIMEOFFSET () might be better

Answer 2

sysutcdatetime () is the best option if your customers are located in another part of the world and you want to use this column to filter or compare goals.