Get date from now() mysql

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()

Similar codes

16 votes173 views6 answers
Mysql find and replace
SQL
0 vote180 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
4 votes238 views1 answer
Postgresql change default value
SQL
2 votes161 views1 answer
When matched in sql server
SQL
1 vote187 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote171 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote166 views1 answer
How to output a different column name in mysql
SQL
0 vote330 views1 answer
The differnece between to values in sql
SQL
0 vote172 views2 answers
Sql use not in
SQL
7 votes172 views4 answers
What is my mysql version
SQL