In the database, store the time in the form of datatime or unix?

Question

SQL

Question for an experienced developer. Prompt in what form it is better to store time in a DB? I work on several projects, somewhere the time is stored in datatime format, and somewhere in unix.

Answer 1

In the format of a field with the "date" type.

Answer 2

The main difference in them is that datetime does not depend on the time zone, and unixtime will return different times depending on the time zone when received, so when using database clients in different time zones, unixtime is more convenient.
Well, of course, the size in bytes is different, with a gigantic amount of data, the choice is made in favor of unixtime.
But if you store unixtime not in the int type fields intended for this and return it without using the built-in database functions to convert to a date, then all the charm of unixtime except for the size is lost.