Fetch only Date and Month from Date

X

naveenkongati

New Member

Join Date: Oct 2008

Posts: 52
#1

Fetch only Date and Month from Date

Nov 11 '08, 03:06 AM

Hi,
How do we fetch only date and month from date column (Ex: 2008-11-10) in Mysql?

Thanks
Tags: None
luttkens

New Member

Join Date: Jul 2007

Posts: 23
#2

Nov 11 '08, 06:24 AM

Take a look at the DATE_FORMAT function. In your case it would be something like

Code:

SELECT DATE_FORMAT(DateField, '%Y-%m-%d') FROM table
Comment

Previous template Next

Comment