Unix Epoc

[DoubleDee]

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


Debbie

[logic_earth]

https://en.wikipedia.org/wiki/Unix_time

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

[DoubleDee]

https://en.wikipedia.org/wiki/Unix_time

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


Debbie

[AnthonySterling]

Whose DateTime format?

date(DATE_ISO8601, 0)

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

[DoubleDee]

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]

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

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