Specific Date Format in mysql

Question

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

I think you have misspelled "May" in your expected output.

Mark Byers
– Mark Byers

2010-08-05 08:00:24 +00:00
Commented Aug 5, 2010 at 8:00 — Mark Byers
– Mark Byers, Commented Aug 5, 2010 at 8:00

Mark Byers · Accepted Answer · 2010-08-05 08:00:54Z

6

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

edited Aug 5, 2010 at 8:00

answered Aug 5, 2010 at 7:55

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Evernoob · Accepted Answer · 2010-08-05 07:56:53Z

1

Like this:

SELECT ID, DATE_FORMAT(`Date`, '%d-%M-%Y') FROM table;

You can find other date formatting options for MySQL here: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

answered Aug 5, 2010 at 7:56

Evernoob

5,5718 gold badges39 silver badges50 bronze badges

Comments

Haim Evgi · Accepted Answer · 2010-08-05 07:56:20Z

0

use DATE_FORMAT() in mysql

look at the link for all format option:

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

answered Aug 5, 2010 at 7:56

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Collectives™ on Stack Overflow

Specific Date Format in mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related