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.
Adding "?zeroDateTimeBehavior=convertToNull? to the URL works at least for SELECT statements.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.