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

0 vote291 views1 answer
Oracle swap partition
SQL
1 vote281 views1 answer
Apex ORA-20999
SQL
0 vote307 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote300 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote283 views1 answer
How to select all fieldsin a soql query
SQL
1 vote269 views3 answers
Psql fatal database does not exist
SQL
0 vote259 views1 answer
Convert sql server guid to varbinary
SQL
0 vote266 views1 answer
Can we rollback data that are deleted using DELETE
SQL
10 votes289 views4 answers
Drop primary key
SQL
0 vote281 views1 answer
Mysql drop trigger
SQL