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')"; // using this for use concat return $this->find('list', array( 'conditions' => $conditions, 'fields' => array( 'MemberBookFacility.id', 'time', ), 'order' => array( 'MemberBookFacility.time ASC', ), ));