UNIX-MySQL date and time converter


MySQL dates are in the form YYYY-MM-DD HH:MM:SS (the time is optional, it will assume midnight on that day). UNIX times are either seconds or milliseconds since midnight on January 1st, 1970.

Millseconds:
Seconds:

Laurie Voss is a developer, writer, and recovering npm co-founder. Writing about technology and what it means for humans since 2001.

More about Laurie →