[Andreas123]

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();
	}

[phtamas]

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');

[Andreas123]

phtamas, on 29 March 2011 - 01:34 PM, said:

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');

yep.. THX that makes sense

[zainiafzan]

Thanks..help me too..

[Istrak]

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: