Hey guys I wonder if someone could help me on this... I'm learning MYSQL and I 've been searching on google... about this particular error on, with no succes which is wierd I'm sure many pple might have had this error. Anyway the problem is when I try to add a date to my DB let's say 1900 or previous dates it gives me this error:

Warning: #1264 Out of range value adjusted for column Yearbuilt

my field is a YEAR(4) NULL type field, in a INNODB table. It has no ENUM or SET values :S
Any help would be much appreciated

    According to MySQL's documentation:

    For four-digit format, MySQL displays YEAR values in YYYY format, with a range of 1901 to 2155. For two-digit format, MySQL displays values with a range of 70 (1970) to 69 (2069).

      Write a Reply...