Re: one other big mysql->postgresql item

I personnally always use '1111-11-11 11:11:11' for that purpose.
It does work on about any DB.

> George Johnson wrote:
>
> Hi,
>
> 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.
>
> George Johnson