Solved

select only date and mont mysql

Posted on 2011-09-10
2
376 Views
Last Modified: 2012-06-27
I have column birthday how can i select only day and month  dd/mm  I donot want year sql state ment on mysql
0
Comment
Question by:teera
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 36516010
0
 
LVL 7

Assisted Solution

by:Kishan Zunjare
Kishan Zunjare earned 250 total points
ID: 36518659
To select date use following
SELECT DATE_FORMAT('2011-09-11 22:23:00', '%D');
Result =>11th

To select day use following
SELECT DATE_FORMAT('2011-09-11 22:23:00', '%W');
Result =>Sunday

To select Only Month use following
SELECT DATE_FORMAT('2011-09-11 22:23:00', '%M');
Result=>Septmeber

I hope this will work.

0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Character matching different date formats for dates between 6 48
sql help 8 55
SQL Server Insert where not exists 24 41
sort in mysql based off of query param 4 24
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question