MySql TIMESTAMP '0' value breaks on select

  • JeffKirby

    JeffKirby - 2006-11-16

    I have a table with timestamps that contain default values ( the timestamp is only added once an event inserts one).
    So I select all or 1 row, but i get

    Cannot Convert Value '0000-00-00 00:00:00' from column 10 to TIMESTAMP

    This is the correct 0 value for the datatype.. so its just a view issue with SQLExplorer.
    reference here

    • Stzzo

      Stzzo - 2008-01-15

      Adding "?zeroDateTimeBehavior=convertToNull? to the URL works at least for SELECT statements.




Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks