MySQL Out of Range Solution for DATETIME field -

MySQL Out of Range Solution for DATETIME field

Affected rows: 0
Warning: #1264 Out of range value adjusted for column 'deleteon' at row 1
SQL query:
UPDATE `custtable`.`custinfo` SET `deleteon` = '2011-02-29 00:00:00' WHERE `custinfo`.`custid` =105 LIMIT 1 ;

This happened after a migration to a new SQL database due to user error.  The old database server MySQL 3.23 or 4 allowed an impossible date to be entered by a user.  As we know February 29th DOES NOT exist but the database allowed the value.  MySQL 5.0 is smarter and rejected it and ended up setting a blank value for that field.  It was hard to troubleshoot at first until we actually looked at the date :)

So the solution is to use Feb-28th or March 1st since the 29th does not exist.


  • Dell CS24 NV5/NV7 Gigabyte GA-3CESL-RH Motherboard ROM Chip info
  • phlash Cannot flash when memory managers ( e.g. HIMEM) are present Phoenix BIOS
  • Weird Ubuntu Issues with NVIDIA driver/Compiz
  • HP Switch 2824 CLI Telnet Experience , Guide and Tutorial
  • rm how to delete a file with -- 2 leading dashes
  • Linux check NIC ethernet port network card speed
  • HP XW9400 Motherboard In Desktop Issues
  • tar list files
  • tar do not overwrite files
  • Dell CS24-NV7 lspci dmidecode info
  • Debian sources.list examples
  • bash check size of file using stat
  • Dell CS24,FS12 NV5 and NV7 1U Server Information & Parts
  • bash script check if string contains text
  • sed linux bash how to remove non-ASCII english characters
  • Linux CLI command to rip audio CD and encode convert to MP3s
  • bash string substitution
  • sed print specific line number
  • Unable to configure RSA server private key SSL Library Error: 185073780 error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch
  • Error code: ssl_error_rx_record_too_long