Change database date format

cPanelAaronH

Well-Known Member
Staff member
Dec 31, 2014
70
19
133
Houston Texas
cPanel Access Level
Root Administrator
Hey there,

It looks like that is already the default format:

Code:
-bash-4.2# mysql -e "SHOW VARIABLES LIKE 'date%';"
+-----------------+-------------------+
| Variable_name   | Value             |
+-----------------+-------------------+
| date_format     | %Y-%m-%d          |
| datetime_format | %Y-%m-%d %H:%i:%s |
+-----------------+-------------------+
Are you having any particular issues with the times set?