current_timestamp只能获得年，月和日

Question

I have an sql query that gets the current timestamp but it gets the entire timestamp and renders it via php. I was wondering how I could only get the year, month, and day and in this format : (month/day/year)

query :

SELECT badge_id, merchant_id, quest_title, quest_price, quest_date, quest_points 
FROM quests WHERE quest_id = $id

Answer 1

As per http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format

SELECT DATE_FORMAT('(%m/%d/%Y)', now()) AS datestring