Forum : What is the difference between Unix timestamps and MySQL timestamps?
Brief description  about Online courses   join in Online courses
View prabeen  patra 's Profile

What is the difference between Unix timestamps and MySQL timestamps?

Hi,

Can anyone give me the difference between Unix timestamps and MySQL timestamps?
Asked by prabeen patra | Oct 27, 2009 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi prabeen,

Internally Unix timestamps are stored as 32-bit integers, while MySQL timestamps are stored in a similar manner, but represented in readable YYYY-MM-DD HH:MM:SS format.
Oct 27, 2009