CODEWITHSUNDEEP
mysqldatetime
user4804299
user4804299

Reputation:

How MySQL DateTime works

I need to manipulate my database. I'm stuck at datetime field. For example, it is 08-Apr-2015 21:13:49 and SQL translate it into 1428527629. How SQL translate the d-M-Y H:i:s format?

Upvotes: 1

Views: 53

Answers (1)

Josi
Josi

Reputation: 96

1428527629 unix timestamp, stands for seconds since Jan 01 1970. (UTC)

You have several SQL functions to work with dates, such as: FROM_UNIXTIME(1428527629)

Upvotes: 2

Related Questions