CakePHP中的MYSQL date Now（）

Question

I have used following for getting mysql date using CakePHP

    $db =& ConnectionManager::getDataSource('default');
    $data['end_date'] = $db->expression('NOW()');

and

$data['end_date'] = DboSource::expression('NOW()');

and

$db = ConnectionManager::getDataSource('default');
$data['end_date'] = $db->expression('NOW()');

Above all things give me below array whenever I print it.

[end_date] => stdClass Object
            (
                [type] => expression
                [value] => NOW()
            )

'end_date' has datetime type. I have also change it to timestamp. but not work.

What I want :

I want to save Now() ( mysql date ) in my database field 'end_date'.

Answer 1

The easiest way is just to use date('Y-m-d H:i:s') (if you are using the TIMESTAMP datatype).

$data['end_date'] = DboSource::expression(date('Y-m-d H:i:s'));

Make sure to set the timezone, or you'll end up with a bunch of warnings, as is PHP's style.