SQL SELECT NOW()
date, mysql, sql
Solution
How about CURDATE()?
SELECT CURDATE()
(Note: this is listed as MySQL in the webpage. Unsure what vendor/version of SQL you're running.)
Problem
Hey ya'll sorry for all the caps in the title, but its actually suppose to be like that. I am running this in query `SELECT NOW()` and it returns this `2012-05-14 17:35:37` how do I remove the time, I only want the date.