Re: Invalid Date Bug

["Keith C. Ivey" <suppressed>]

On 14 Feb 2003, at 16:43, Don Vu wrote:

> Is it just me, or does Mysql allow invalid dates to be entered into
> columns with date datatype?

See the documentation (http://www.mysql.com/doc/en/DATETIME.html):

    The MySQL server only performs basic checking on the validity of
    a date: days 00-31, months 00-12, years 1000-9999. Any date not
    within this range will revert to 0000-00-00. Please note that
    this still allows you to store invalid dates such as 2002-04-31.
    It allows web applications to store data from a form without
    further checking. To ensure a date is valid, perform a check in
    your application.

-- 
Keith C. Ivey <suppressed>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php