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

R

Roman Rakzin2017-06-26 21:37:48

Working with date/time

Roman Rakzin, 2017-06-26 21:37:48

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?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

N

n-fom, 2017-06-27
@n-fom

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...