how to allow zero dates in mysql?

Yii 1.1 General Discussion
1

How can I configure mysql connection to allow zero dates?

Thanks

2

Two simple solutions:

  1. Use INT timestamps;

  2. Use field NULL value as zero date.

3

simple , you can use date format but you have to allow null values ,

and ofcourse you can give it default value.

4

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.

5

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

6

I changed mysql strict mode to off and this fixed it, but I may not be able to do this in production.

7

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

                        ..

                        ..