Hello, everybody.
Is it possiblle to use MySql functions (for example STR_TO_DATE(str,format)) within CActiveRecord object?
Thanks.
Hello, everybody.
Is it possiblle to use MySql functions (for example STR_TO_DATE(str,format)) within CActiveRecord object?
Thanks.
You can do this:
$user = User::model()->findByPk(1);
$user->someDate = new CDbExpression("ANY VALID SQL COMMAND");
$user->save();
Y!!, thank you for your quick reply.
It works greate.
No problem. You may also bind params for security reasons.
new CDbExpression("MD5(:example)", array(':example' => $example));