Mysql:创建表时将DATETIME的格式设置为'DD-MM-YYYY HH:MM:SS'

Mysql: Setup the format of DATETIME to #39;DD-MM-YYYY HH:MM:SS#39; when creating a table(Mysql:创建表时将DATETIME的格式设置为DD-MM-YYYY HH:MM:SS)

问题描述

After googling around, I cannot find a way to create a new table with a DATETIME column with the default format set to 'DD-MM-YYYY HH:MM:SS'

I saw a tutorial in which it was done in phpmyadmin so I suspect that I could use mysql via command line and achieve the same thing when creating my new table with

CREATE TABLE ()

Thank you in advance

"MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format." This is from mysql site. You can store only this type, but you can use one of the many time format functions to change it, when you need to display it.

Mysql Time and Date functions

For example, one of those functions is the DATE_FORMAT, which can be used like so:

SELECT DATE_FORMAT(column_name, '%m/%d/%Y %H:%i') FROM tablename

这篇关于Mysql:创建表时将DATETIME的格式设置为'DD-MM-YYYY HH:MM:SS'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！