current date

Sometimes you may need to get date from datetime, or get current datetime. Here is how to get current date and time in MySQL.