Hi MySql Community,
I put up a default null value TIMESTAMP on field type TIMESTAMP. Now I enter to
the database as '0000-00-00 00:00:00' default for null value. From this on, I
mapped it using hibernate with mysql-connector-java-3.1.6-bin.jar driver. I
extract it but error occurred:
Caused by: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00'
from column 9 to TIMESTAMP.
What did I done wrong? Is there a problem with the driver? Or should I use
DATETIME instead? Some says the format is supposed to be '0000-00-00 00.00.00'
instead, if so this would be a database problem, is this a some kind of
unresovled bug? Lastly, any remedy for the meantime for this?
Thanks a lot.
Melvin R. Zamora
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates
starting at 1¢/min.
