I have a "datetime" field and use my native calendar format to store data in it .
I`m using jalali calendar . when I add 1388-04-30 00:00:00 database accept it but when I add 1388-04-31 00:00:00 in phpMyadmin I receive this error :
Affected rows: 0
Warning: #1264 Out of range value adjusted for column 'orderDate' at row 1
How could I solve it?
I`m using mysql 5.0.51 ...
mysql supports only one calendar, and 04-31 is not vald
Wow, what should I do now?
I have defined "datetime" field type in all of my project tables;
MySQL should have a logical solution for other countries date types; hasn`t it?