George Johnson writes:
> Forgot one other biggy:
>
> 0000-00-00 00:00:00
>
> is legal for a default value of '' of a datetime column defined as not null.
>
> create table test (
> funkydate datetime not null;
> );
>
> insert into test values ('');
>
> select * from test where funkydate = '0000-00-00 00:00:00';
>
> all those work, in MySQL, and I'm willing to bet a LOT of users have code reflecting that.
Just because MySQL violates century-old time keeping conventions, SQL, and
common sense that doesn't mean it's right. If you want to store
'0000-00-00 00:00:00' in your database then you can use the character
types.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/