How to create a timestump record type in MS Sql Server so that the value is inserted as a UNIX time when inserted?

Question

Working with date/time

How to create a timestump record type in MS Sql Server so that the value is inserted as a UNIX time when inserted?
By default, if I set the timestump type, nonsense is written there (that is, the version of the line and something else), but obviously not the necessary timestump. How to install a timestump or then generate it in c# and insert it as an int?

Answer 1

It is not entirely clear why you need to store an inappropriate type in the database, when in this case you can convert "on the fly". Well, if you really want to, you can create a calculated column and use the conversion function hardeepamritsar.blogspot.ru/2008/05/converting-dat...