Wednesday, April 11, 2012

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


Thanks for reporting it.

Rob


On Sat, Mar 17, 2012 at 2:32 PM, Markus Unger <markus.unger1985@googlemail.com> wrote:
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