0000-00-00 gives me grief

See http://symfoniac.wordpress.com/2007/09/13/warning-about-php-524-and-creole/

in r6003 and r6004

This never ported to mysqli/MySQLiResultSet.php. Couldn't figure out why when using the latest 1.0 branch of symfony I was still getting these types of errors about 0000-00-00. Turns out someone patched MySQLResultSet but never did MySQLiResultSet.

diff -ur MySQLiResultSet.php.orig MySQLiResultSet.php
--- MySQLiResultSet.php.orig	2008-07-07 09:20:01.000000000 -0500
+++ MySQLiResultSet.php	2008-07-07 09:21:47.000000000 -0500
@@ -130,21 +130,11 @@
      */
     public function getTimestamp($column, $format='Y-m-d H:i:s')
     {
-        if (is_int($column)) {
-            // because Java convention is to start at 1
-            $column--;
-        }
-
-        if (!array_key_exists($column, $this->fields)) {
-            throw new SQLException("Invalid resultset column: " . (is_int($column) ? $column + 1 : $column));
-        }
-
-	if ($this->fields[$column] === null) {
-		return null;
-	}
+        if (is_int($column)) { $column--; } // because Java convention is to start at 1
+        if (!array_key_exists($column, $this->fields)) { throw new SQLException("Invalid resultset column: " . (is_int($column) ? $column + 1 : $column)); }
+        if ($this->fields[$column] === null || $this->fields[$column] == '0000-00-00 00:00:00') { return null; }
 
         $ts = strtotime($this->fields[$column]);
-
         if ($ts === -1 || $ts === false) { // in PHP 5.1 return value changes to FALSE
             // otherwise it's an ugly MySQL timestamp!
             // YYYYMMDDHHMMSS
@@ -159,11 +149,9 @@
             // if it's still -1, then there's nothing to be done; use a different method.
             throw new SQLException("Unable to convert value at column " . (is_int($column) ? $column + 1 : $column) . " to timestamp: " . $this->fields[$column]);
         }
-
         if ($format === null) {
             return $ts;
         }
-
         if (strpos($format, '%') !== false) {
             return strftime($format, $ts);
         } else {

(In [10948]) [1.0, 1.1, 1.2] fixed 0000-00-00 dates in mysqli creole driver (closes #2234)

[10948] looks like a bad merge maybe, public function getDate() starts half way through getTimestamp() (line 151).

It's been fixed in r11017