Incorrect datetime '0000-00-00 00:00:00' with temporary table
Posted by:
Wim Roffel
Date: December 20, 2017 01:59PM
I have a command creating a temporary table
CREATE TEMPORARY ordertemp (SELECT * from orders WHERE ...)
The original table contains some datetimes that are zero ('0000-00-00 00:00:00'). I have this working on several servers where that is no problem. However, on one server I get the error:
Incorrect datetime value: '0000-00-00 00:00:00' for column 'invoice_date' at row 2
My questions are:
- what could cause this?
- what can I do about it?
Subject
Written By
Posted
Incorrect datetime '0000-00-00 00:00:00' with temporary table
December 20, 2017 01:59PM
December 20, 2017 04:44PM
December 21, 2017 02:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.