Hello,
We are doing a select query from our php application using mysqli functions .
the datatype of LastLogin is "datetime" and default value is
"0000-00-00 00:00:00" in mysql database.
We are getting the below error in this case
Cannot convert value '0000-00-00 00:00:00' from column 12 to TIMESTAMP.
We are using sequoia-2.10.9 , carob-0.7.3-1, mysql-5.0.22 and
mysql-connector-java-3.1.14-bin.jar
Below is the php code for reference.
<?php
$link = mysqli_connect("192.168.1.33:25323", "myuser", "mypass", "mydb");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = "select LastLogin from register_table limit 1,2";
$result = mysqli_query($link, $query);
/* numeric array */
$row = mysqli_fetch_array($result, MYSQLI_NUM);
printf ("%s (%s)\n", $row[0], $row[1]);
/* associative array */
$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);
/* associative and numeric array */
$row = mysqli_fetch_array($result, MYSQLI_BOTH);
printf ("%s (%s)\n", $row[0], $row["CountryCode"]);
/* free result set */
mysqli_free_result($result);
/* close connection */
mysqli_close($link);
?>
Any help will be appreciated.
Regards
Suresh N
_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
https://forge.continuent.org/mailman/listinfo/sequoia
