Mysql current date

In MySQL the CURDATE() returns the current date in 'YYYY-MM-DD' format or 'YYYYMMDD' format depending on whether numeric or string is used in the function. CURRENT_DATE and CURRENT_DATE() are the synonym of CURDATE()

Get date from now() mysql

You can use CURDATE()

Mysql current date

SELECT NOW();
It returns current date and time.

Similar codes

39 votes217 views5 answers
Sql drop column
SQL
0 vote209 views1 answer
Mysqlcli how to load external sql file
SQL
19 votes231 views5 answers
Display table in sql
SQL
0 vote208 views2 answers
How to list all values of a column that start with a letter in sql
SQL
17 votes207 views3 answers
Cast in sql server
SQL
1 vote220 views1 answer
Mysql alter decimal precision
SQL
0 vote207 views1 answer
Import big data to mysql
SQL
0 vote205 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote204 views1 answer
Sql_inner_join
SQL
12 votes202 views1 answer
Docker mysql random root password
SQL