How to generate DATETIME data type for MySQL

Yii 1.1 General Discussion
1

there is mySQL data type called DATETIME. I am trying this code to generate the time stamp to save into mySQL, but it doesn’t work. Nothing is saved.


$user->created = date("YYYY-MM-DD HH:MM:SS");

Can you tell me who to create the date and time to save into DATETIME data type in MySQL?

Thank you!

2

use timestamp, do not use date. so in php u can manage by time()

3

try this, it will work




$user->created  = new CDbExpression('now()');
4

Thanks you!