Saturday, March 17, 2012

Re: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

SELECT TIMESTAMP('0001-01-01 00:00:00') as t works...

SELECT TIMESTAMP('0000-00-00 00:00:00') as t not working...

But the column is null.. so the correct result must be "NULL" and not "0000-00-00 00:00:00"... 

No comments:

Post a Comment