Correct Format for Producing MySQL TIMESTAMPS

This is the correct formatting to use when using the date() function when building MySQL TIMESTAMPS.

    date("Y-d-m H:i:s");

Example: 2009-21-07 20:58:15

Other than that it’s pretty simple. Unfortunately, MySQL doesn’t support Unix Timestamps, which would mean that it’s a good idea to have a function to deal with this.

Posted at 8:00 on 2 st July 2009