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