aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Problem while converting datatime to timestamp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem while converting datatime to timestamp" Watch "Problem while converting datatime to timestamp" New topic
Author

Problem while converting datatime to timestamp

Shantanu Deshmukh
Greenhorn

Joined: Jul 28, 2011
Posts: 23

Hello,
I am writing a simple jdbc program, which will print data column in my table. I use this statement users.getString('update_time')
The field in my database contains, for e.g, this value 2010-01-12 20:54:35.0.
The program prints this value, but also throws exception as Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP.

Please help !!


There are no failures, only experiences
Shantanu Deshmukh
Greenhorn

Joined: Jul 28, 2011
Posts: 23

Hey folks, got a solution for that.
zeroDateTimeBehavior=convertToNull add this as a parameter in JDBC connection url to slove this problem

Hope this helps to whoever reaching to this problem
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem while converting datatime to timestamp