what is the difference between now() and current_date()?
snippet in sql

what is the difference between now() and current_date()?

user1056

NOW() command is used to show current year, month, date with hours, minutes and seconds.
CURRENT_DATE() shows current year, month and date only.