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