| 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 
|
|
 |
|
|
subject: Problem while converting datatime to timestamp
|
|
|
0
