datetime « mysql « Java Database Q&A

1. Java/MySQL - datetime problem    stackoverflow.com

!!IMPORTANT!! Solution found, you need to use a sql.timestamp. Although there are 2 problems with the timestamp. First of all if you want to put an Date into an Timestamp you need ...

2. Comparing MySQL and Java Time    stackoverflow.com

I have a datetime field in MySQL which I access through calling result.getString('date'), now I would like to check weather the current date and time in Java has exceeded the MySQL ...

3. datetime type in Mysql database    stackoverflow.com

I have a field in my database (MYSQL) with datetime type (with this format 2011-05-18 16:29:31), I dont know this type! because I Have to convert a String to this type. I ...

4. MySQL: Data truncation: Incorrect datetime value: '2006-10-01 02:22:44'    stackoverflow.com

I'm getting the following exception updating a row using MySQL via JDBC:

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '2006-10-01 02:22:44'

'created_on_service timestamp NULL DEFAULT NULL'

5. MySQL - Date/Time and Timestamp Issues    coderanch.com

Everyone who's played around with JDBC and Date/Time values, knows mastering this can be a pain. For the most part you can do everything you want in Java using the getTime() field for milli-seconds past the epoch. Oh, you can use the Calendar utility methods for more complicated things, but getTime() often solves your basic needs and is useful in transferring ...

6. converting a mysql DATETIME (HH:mm:ss) to seconds    coderanch.com

7. Java - Mysql Datetime problem    forums.oracle.com

EDIT: okay, I think I found the solution in the Connector J Docs: Datetimes with all-zero components (0000-00-00 ...) ? These values can not be represented reliably in Java. Connector/J 3.0.x always converted them to NULL when being read from a ResultSet. Connector/J 3.1 throws an exception by default when these values are encountered as this is the most correct behavior ...