note 54528 added to ref.mysql

/* * before mysql 4.1, timestamp have a defined size, but after 4.1, timestamp is equal to... datetime * so, conversion is automatic when you import your dump in new mysql version, but your script cannot echo dates like before. * this function took one date on DATETIME format, a size of old timestamp format and return the date in old timestamp format before 4.1 * Note : if $date is in TIMESTAMP format, the function return it unaltered. So we can patch our php code before migrate to 4.1 * @param $date a date in DATETIME format, or TIMESTAMP format after mysql 4.1 * @param $size a size of old TIMESTAMP format (14,12,10,8,6,4 or 2) * @return the date in old TIMESTAMP format */ function mysql_convert_timestamp_to_previous_usage($date, $size) { $tab=split('[- :]', $date); if (sizeof($tab) != 6) return $date; if (($size!= 8) && ($size!= 14)) { $tab[0]=substr($tab[0], -2); } for ($i = 12; $i>$size; $i-=2) { unset($tab[sizeof($tab)-1]); } if ($size== 8) unset($tab[sizeof($tab)-1]); return implode("", $tab); } ---- Manual Page -- http://www.php.net/manual/en/ref.mysql.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+54528 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+54528&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+54528&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+54528&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+54528&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+54528&report=yes&reason=non-english Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+54528&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+54528&report=yes Search -- http://master.php.net/manage/user-notes.php