Unix Epoc

DoubleDee · February 11, 2012, 3:33am

Is the time at the Unix Epoch equal to zero (0) ??

Debbie

logic_earth · February 11, 2012, 3:49am

The Unix time number is zero at the Unix epoch, and increases by exactly 86 400 per day since the epoch.

DoubleDee · February 11, 2012, 4:02am

How would I represent the Unix Epoch in the DateTime format?

Debbie

AnthonySterling · February 11, 2012, 1:08pm

Whose DateTime format?


date(DATE_ISO8601, 0)


1970-01-01T00:00:00+0000

DoubleDee · February 11, 2012, 4:11pm

AnthonySterling:

Whose DateTime format?
date(DATE_ISO8601, 0)
I meant DateTime format in MySQL.

So, if I wanted to store the Unix Epoch in a MySQL DateTIme field what would I enter?

Thanks,

Debbie
1970-01-01T00:00:00+0000

r937 · February 11, 2012, 5:43pm

you would first need to decide whether you wanted your mysql table to store an actual datetime value, in which case your choices for datatype are DATETIME and TIMESTAMP, or whether you wanted to store the actual unix epoch number, in which case your choice is limited to INTEGER