Menu

#121 Mysql column type year displays incorrect in adodb-pager

open
nobody
None
5
2011-01-25
2011-01-25
bzcat
No

Using adodb 5.11
PHP 5.2.10
mysql 5.0.89

All values stored in a year(4) are all displayed as "Wed 31, Dec 1969"

Steps to reproduce
Using a Mysql adodb connection, create a table with a column of type year(4), with values 2005, 2006, 2007....

require_once('adodb.inc.php');
require_once('adodb-pager.inc.php');
$db = NewADOConnection('mysql'); // A new connection
$db->NConnect($host, $newuser, $newpass, $database, MYSQL_CLIENT_SSL);

$sql = "select * from table';
$pager = new ADODB_Pager($db, $sql);
$pager->Render();

Discussion