Answers for "how to change mysql date format"

SQL
1

mysql pretty date format

DATE_FORMAT(NOW(),'%M %e, %Y @ %h:%i %p') 
#Format is 'June 10, 2014 @ 06:52 PM'
Posted by: Guest on November-27-2019
1

date conversion in mysql column

MySQL DATE_FORMAT() formats a date as specified in the argument. A list of format specifiers given bellow may be used to format a date. The ‘%’ is required before the format specifier characters.

Syntax:

DATE_FORMAT(date,format)
Posted by: Guest on January-23-2021

Code answers related to "how to change mysql date format"

Code answers related to "SQL"

Browse Popular Code Answers by Language