How to get date & month using date in mysql

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`) – Alive to die - Anant Jun 06 '17 at 08:51 — Alive to die - Anant, Jun 06 '17 at 08:51

score 2 · Answer 1 · answered Jun 06 '17 at 08:51

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 06 '17 at 08:51

Eduard Void

2,646
1
13
13

Its working. Thanks! – Pradnya Jun 06 '17 at 09:01
Someone that actually read the question +1 – RiggsFolly Jun 06 '17 at 09:04
if i want to display data from date & month?? SELECT * FROM tbl_name WHERE dob = '-06-06'; – Pradnya Jun 06 '17 at 09:17
SELECT * FROM tbl_name WHERE DATE_FORMAT(dob, '-%m-%d') = '-06-06' – Eduard Void Jun 06 '17 at 09:20
Thank you Eduard! – Pradnya Jun 06 '17 at 09:25

score 0 · Answer 2 · answered Jun 06 '17 at 08:52

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

score 0 · Answer 3 · answered Jun 06 '17 at 08:53

0

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

answered Jun 06 '17 at 08:53

ManiMuthuPandi

1,594
2
26
46

Please explain your answer code on it's own is useless explain how it helps the OP with there problem. – Barkermn01 Jun 06 '17 at 15:37

score 0 · Answer 4 · answered Jun 06 '17 at 09:01

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 06 '17 at 09:01

Kruti Aparnathi

175
1
11

How to get date & month using date in mysql

4 Answers4