mysql中的集中日期格式,MySQL中的特定日期格式
Using MySQL
Table
ID Date
001 2010-05-01
002 2010-06-08
Query
Select ID, Date from table;
I want to display a date in a specific format
Expected Output
ID Date
001 01-Mar-2010
002 08-June-2010
How to make a query in mysql.
Need Query Help
解决方案
You can use DATE_FORMAT with the format string '%d-%M-%Y'.
CREATE TABLE table1(ID varchar(100), Date datetime);
INSERT INTO table1 VALUES
('001', '2010-05-01'),
('002', '2010-06-08');
SELECT ID, DATE_FORMAT(Date, '%d-%M-%Y') FROM table1;
Result:
ID Date
001 01-May-2010
002 08-June-2010