Unix Epoc

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


Debbie

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

Quote:

---

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

---

Quote:

---

Originally Posted by logic_earth

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

---

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


Debbie

Whose DateTime format?

Code:

---

date(DATE_ISO8601, 0)

---

Code:

---

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

---

Quote:

---

Originally Posted by AnthonySterling

Whose DateTime format?

Code:

---

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

Code:

---

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

---

---

Quote:

---

Originally Posted by DoubleDee

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