DB Attribute with TIMESTAMP - Not possible to save timestamp

Yii 1.1 General Discussion
1

Hey guys,

I have an attribute called "date" in my DB with the datatype "TIMESTAMP"

When executing the following code in my model the following data is saved in the DB:


0000-00-00 00:00:00

(instead of the timestamp…)

Model Code:




	protected function beforeValidate()

	{		

		$this->date = time(); 


		return parent::beforeValidate();

	}
2

Your DBMS doesn’t accept an integer value for a timestamp column. It needs to be converted to a properly formatted string:




$this->date = date('Y-m-d H:i:s');
3

yep… THX that makes sense

4

Thanks…help me too… :lol:

5

Don’t Work for me I use this code




$model->fechora=date('Y-m-j h:i');

And show this error

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: