Re: '0000-00-00' is an invalid date

From: bill <william_at_TechServSys.com>
Date: Sun, 4 Feb 2018 15:29:06 -0500
Message-ID: <p57qei$17pj$2_at_gioia.aioe.org>

On 2/4/2018 1:04 PM, John Levine wrote:
> In article <p56vs9$1m6n$1_at_gioia.aioe.org> you write:

>> I can SELECT * FROM `episodes` where `ending` = '0000-00-00'
>> without error, but
>> update`episodes`  set `ending` = NULL
>> where `ending` = '0000-00-00'
>> gives me the error.
>>
>> any suggestions how to render the 'ending' field updatable?

>
> Valid dates start at '1000-01-01', and I doubt that any of your episodes are more
> than 900 years old, so try this:
>
> update `episodes` set `ending` = NULL where `ending` < '1200-01-01'
>
> If you want to make sure those are the right ones, you can try this first:
>
> select * from `episodes` where `ending` < '1200-01-01'
>
Good thought - i'll try that if I can't figure out how to change the mode.
-bill Received on Sun Feb 04 2018 - 21:29:06 CET