How do I get the date part of a timestamp in MySQL?
# Version 4.1.1+
DATE(timestamp)
# Older versions
DATE_FORMAT(timestamp, '%Y-%m-%d')
FAQ TA Browse questions and answers by category Latest questions and answers Pending questions Post question
Omniscient FAQ-service
# Version 4.1.1+
DATE(timestamp)
# Older versions
DATE_FORMAT(timestamp, '%Y-%m-%d')