How to get date & month using date in mysql [duplicate]

Question

I want to get date & month from date. example 2017-06-15 so I want date & month i.e. -06-15. Do u have any idea? Really appreciated.

From Below query I am getting month from date. but I want both date & month

SELECT MONTHNAME(`date`) AS month_name FROM table_name;

use DATE(date)

Death-is-the-real-truth
– Death-is-the-real-truth

2017-06-06 08:51:55 +00:00
Commented Jun 6, 2017 at 8:51 — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jun 6, 2017 at 8:51

Eduard Void · Accepted Answer · 2017-06-06 08:51:27Z

2

SELECT DATE_FORMAT(date, '-%m-%d') AS month_name FROM table_name;

see the date_format documentation to see all the possible formats

answered Jun 6, 2017 at 8:51

Eduard Void

2,7041 gold badge16 silver badges14 bronze badges

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

5 Comments

Pradnya Over a year ago

Its working. Thanks!

RiggsFolly Over a year ago

Someone that actually read the question +1

Pradnya Over a year ago

if i want to display data from date & month?? SELECT * FROM tbl_name WHERE dob = '-06-06';

Eduard Void Over a year ago

SELECT * FROM tbl_name WHERE DATE_FORMAT(dob, '-%m-%d') = '-06-06'

Pradnya Over a year ago

Thank you Eduard!

Bipin Kareparambil · Accepted Answer · 2017-06-06 08:52:10Z

MySQL MONTH() returns the MONTH for the date within a range of 1 to 12 ( January to December). It Returns 0 when MONTH part for the date is 0.

SELECT MONTH('2009-05-18');

MySQL DAY() returns the day of the month for a specified date. The day returned will be within the range of 1 to 31. If the given date is ‘0000-00-00’, the function will return 0. The DAYOFMONTH() is the synonym of DAY().

SELECT DAY('2008-05-15');

Link : here

ManiMuthuPandi · Accepted Answer · 2017-06-06 08:53:00Z

0

select month('2017-06-15'),DAY('2017-06-15')

answered Jun 6, 2017 at 8:53

ManiMuthuPandi

1,6042 gold badges29 silver badges49 bronze badges

1 Comment

Barkermn01 Over a year ago

Please explain your answer code on it's own is useless explain how it helps the OP with there problem.

Kruti Aparnathi · Accepted Answer · 2017-06-06 09:01:14Z

0

you can use this function

DATEPART(datepart,date)

use below query

SELECT DATEPART(yyyy,datecolumn) AS dateYear,
DATEPART(mm,datecolumn) AS dateMonth,
DATEPART(dd,datecolumn) AS dateDay
FROM table_name

answered Jun 6, 2017 at 9:01

Kruti Aparnathi

1751 silver badge11 bronze badges

Collectives™ on Stack Overflow

How to get date & month using date in mysql [duplicate]

4 Answers 4

5 Comments

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

1 Comment

Comments

Linked

Related