Saving timestamps in the database, displaying local time

[morbiuswilters]

@Sir Twist said:

I’ve been using DateTimeOffset (in .NET) and storing them in the database (MS-SQL) as DATETIMEOFFSETs. That way, the conversion happens automatically when you call the proper DateTimeOffset.ToString() overload.

From my 30s of Googling .NET and T-SQL, that looks exactly like what I would do.