PHP Format Any Time/Date for MySQL

Many people find the act of formatting a date or time for input into a MySQL database tedious. It's actually very simple. Here is a function that will take a timestamp value such as time() or a human readable string and format it for MySQL. MySQL format is: 'YYYY-MM-DD HH:MM:SS' The output of this little script would look something like:

2005-04-20 21:54:00
2000-09-10 04:30:00
2000-09-15 00:00:00

[code lang="php"]'; echo sql_date_format("10 September 2000 4:30 AM").'
'; echo sql_date_format("next Thursday").'
'; function sql_date_format($value) { // Very simple function to prepare a time/date value to // input into a MySQL database. Can accept both string // values as well as timestamps. // This function is used in my database class available // at http://www.micahcarrick.com/2005/04/19/php-mysql-database-class/ if (gettype($value) == 'string') $value = strtotime($value); return date('Y-m-d H:i:s', $value); } ?>[/code]