MySQL Forums
Forum List  »  General

Re: Error when writing using date aggregate
Posted by: Judah Wright
Date: April 29, 2020 08:19AM

That is kinda the problem. Running a SELECT query gets us the results we want, but if we try to do a write with the results of said SELECT query we get an error saying zero-dates are invalid.

Somewhere between the SELECT and the INSERT/UPDATE, one or more of the timestamp aggregates is being cast to zero and I dont have the first clue of how to troubleshoot or who I need to talk to about it.

Options: ReplyQuote

Written By
Re: Error when writing using date aggregate
April 29, 2020 08:19AM

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.