Comment by bob1029

This is the best path in my experience. I typically store timestamps as 64-bit unix seconds in the same way.

On the application side, I use Dapper and DateTimeOffset to map these to a domain type with proper DateTime/UTC fields.

I've found that storing time as integers in the database has some interesting upsides. For example, range queries over the field tend to be faster.