How can I configure mysql connection to allow zero dates?
Thanks
How can I configure mysql connection to allow zero dates?
Thanks
Two simple solutions:
Use INT timestamps;
Use field NULL value as zero date.
simple , you can use date format but you have to allow null values ,
and ofcourse you can give it default value.
Thanks,
I am using the yii-user extension and am getting exceptions on the blank birthdate.
Trying to figure out what I can do.
It is defined as a date field. I have allow null checked, but still fails.
value 0000-00-00
error Birthdate must be date.
in yii-user extension
I can blank out this value and get no errors because I turned off mysql strict mode
I changed mysql strict mode to off and this fixed it, but I may not be able to do this in production.
Hi , please check your relative model as you might use like ,
public function rules()
{
return array(
array('NAME, DATE', 'required'), // You might use date as required so it shows error
..
..