Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In my MySQL server, I have rows that have the date of my created content. Example: 2013-03-17 02:53:47

For now, I am using:

$date = $fetch[thedaterownamegoeshere];

<?php echo $date; ?>

But instead of getting the full content of the date (2013-03-17 02:53:47), I'd like to get only the month – in this example, I wish to have the number "03" as the result. How can I do that?


share|improve this question
up vote 4 down vote accepted


You could use the MONTH() function

mysql> select MONTH(NOW());
| MONTH(NOW()) |
|            3 |
1 row in set (0.03 sec)

mysql> select MONTH('2013-03-17 02:53:47');
| MONTH('2013-03-17 02:53:47') |
|                            3 |
1 row in set (0.04 sec)


You would have to put the MONTH function into the SQL command you are running.


You could also try the PHP Date Function

$month = date("m",$date)

Give it a Try !!!

share|improve this answer
Thank you! Worked fine. :) – André Bazaglia Mar 17 '13 at 5:21
Also DATE_FORMAT(date_column, '%c') to get '3' as result and DATE_FORMAT(date_column, '%m') to get '03' as result. – ypercubeᵀᴹ Mar 17 '13 at 11:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.