date time in mysql code example
Example 1: mysql current time
CURRENT_TIME return HH:ii:ss format time in mysql
Example 2: format time mysql
-- use DATE_FORMAT with %H %i
-- SELECT DATE_FORMAT(MemberBookFacility.time, '%H:%i')
"45": "09:00",
"24": "10:00",
"42": "11:00",
"48": "12:00",
-- ONcakephp must use below format
$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',
),
));
Example 3: date mysql
-- sintax of date type in mysql:
-- ' YYYY-MM-DD '
SELECT *
FROM table
WHERE date_to_find = '2020-05-25'