Re: Blank date field.. Help...

On Wednesday 17 Jul 2002 6:43 am, Bruce Momjian wrote:
> ryan@fdcsmail.darktech.org wrote:
> > Hi,
> >   Is there any way that I can do, just to make my date columns to accept
> > null/blank values? I use the latest stable version.
>
> Uh, you sure can.  Can you show us the query that is failing.  Unless
> the column is marked as NOT NULL, inserting a NULL should be fine.  It
> will not accept '', only NULL.

Those trying to produce cross-platform SQL should be aware that MySQL does
accept blank dates. It gets silently converted to "0000-00-00". This is
considered a feature (check their online manual for details).

Got bitten by this with a bug in one of my apps - couldn't understand what was
happening until I looked at the data being stored.

- Richard Huxton