What are the benefits of using unixtime and datetime in MySql?

E

E

Externus2015-07-19 09:31:08

MySQL

Externus, 2015-07-19 09:31:08

What are the benefits of using unixtime and datetime in MySql?

What are the benefits of using unixtime and datetime in MySql?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Stalker_RED, 2015-07-19
@Stalker_RED

Datetime is readable. Unix timestamp is free from problems with leap seconds, daylight savings time, and so on.
Those. how deprived. Of course, if you compare the time on the day of the clock change as yesterday = today - 60 * 60 * 24, then you get an erroneous result. But the situation will not arise that you have the same time in the logs twice.

Similar questions

A

Alexander Sinitsyn2017-11-23 16:27:38

Is there something like codewars with pascal? 3Reply

D

Dima2017-12-10 18:11:45

How to enable the equivalent of Extras in Photoshop for Adobe Illustrator? 1Reply

K

Kizzeon2020-04-10 21:11:22

How to implement text-align: justify but with the last line on the right side? 4Reply

B

bigProblem2017-10-16 21:47:05

How to write a recursive procedure in MySQL? 2Reply

L

lb-web2017-10-16 23:17:13

How to output related mysql values? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question