Tag Archive

Format PHP Date to MySQL Format

Published on May 17, 2008 By admin

When you insert or update a date in a mysql Table you have to remember that Mysql have 3 types of date DATETIME         ( default format 0000-00-00 00:00:00 ) DATE                ( default format 0000-00-00 ) TIMESTAMP      ( default format 0000-00-00 00:00:00 ) PHP code:       DATE ->  $mysqldate = date( ‘Y-m-d’ );       DATETIME, TSTAMP [...]