mysql format date
snippet in sql

mysql format date

user6198

DATE_FORMAT(date, format)
-- E.g.
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats

mysql pretty date format

user1135

DATE_FORMAT(NOW(),'%M %e, %Y @ %h:%i %p') 
#Format is 'June 10, 2014 @ 06:52 PM'

mysql select ymd

user8145

SELECT DATE_FORMAT(created_at, '%Y-%m-%d') as ymd

format time mysql

user5363

-- 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',
          ),
        ));