Skip to content

Instantly share code, notes, and snippets.

@jwoschitz
Created September 12, 2011 11:43
Show Gist options
  • Save jwoschitz/1211077 to your computer and use it in GitHub Desktop.
Save jwoschitz/1211077 to your computer and use it in GitHub Desktop.
Get date part in MySQL
SELECT DATE('2011-09-10 11:24:03');
#Prints 2011-09-10
SELECT CURDATE()
#Prints the current date, e.g. 2011-09-10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment