This article is tagged with:
Sql server current date without time
and mysql
sql server current date without time
SELECT CAST (GETDATE() AS DATE)