MySQL Forums
Forum List  »  Quality Assurance

Re: SELECT * DATE_FORMAT ???
Posted by: Campus Recruitments
Date: February 13, 2012 03:21AM

SELECT DATE_FORMAT(event_date,'%s %b %d') as event_date FROM `tbl_eventsName` WHERE `event_date` >= CURDATE() ORDER BY event_date LIMIT 4

If you want any other fields as well then you'll need to add them as a comma separated list after the select.



Upcoming Bank Exams
Bank jobs 2012

Options: ReplyQuote


Subject
Views
Written By
Posted
2361
January 22, 2012 05:05AM
Re: SELECT * DATE_FORMAT ???
1892
February 13, 2012 03:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.