List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:December 13 1999 1:11pm
Subject:Re: MySQL Invalid Date Problem
View as plain text  
Enoch Chan writes:
 > 
 > We found that we were able to input invalid dates into a MySQL datetime
 > field (version 3.22.27 on Sparc Solaris 2.6) such as "Nov 31, 1999".  A
 > sample statement would be:
 > 
 >     update user_detail set last_update_date = '1999-06-31';
 > 
 > Is there a way to have these types of records rejected or response with
 > an error message?
 > 
 > Thanks,
 > Enoch
 > 
 > 
 > 
 > 
 > 

Hi!

No, there is not. You will have to check them out in your program.

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
MySQL Invalid Date ProblemEnoch Chan13 Dec
  • Re: MySQL Invalid Date Problemsinisa13 Dec
    • Re: MySQL Invalid Date ProblemPeter Campbell13 Dec
      • Re: MySQL Invalid Date ProblemMichael Widenius28 Dec
RE: MySQL Invalid Date ProblemQuentin Bennett14 Dec