time format in mysql code example
Example 1: mysql now format
SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %H-%i-%s')
Example 2: mysql format date
DATE_FORMAT(date, format)
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
Example 3: MySQL datetime format
use \Datetime;
$now = new DateTime();
echo $now->format('Y-m-d H:i:s');
echo $now->getTimestamp();
Example 4: format time mysql
"45": "09:00",
"24": "10:00",
"42": "11:00",
"48": "12:00",
$this->virtualFields['time'] = "DATE_FORMAT(MemberBookFacility.time, '%H:%i')";
return $this->find('list', array(
'conditions' => $conditions,
'fields' => array(
'MemberBookFacility.id',
'time',
),
'order' => array(
'MemberBookFacility.time ASC',
),
));