mysql date format change structure code example
Example: mysql pretty date format
DATE_FORMAT(NOW(),'%M %e, %Y @ %h:%i %p')
#Format is 'June 10, 2014 @ 06:52 PM'
DATE_FORMAT(NOW(),'%M %e, %Y @ %h:%i %p')
#Format is 'June 10, 2014 @ 06:52 PM'