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

1 vote279 views3 answers
Postgresql crete view
SQL
8 votes299 views1 answer
Oracle create datafile
SQL
0 vote278 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
1 vote320 views1 answer
Oracle plan hash value
SQL
1 vote300 views1 answer
Oracle sql first day of year
SQL
0 vote283 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
5 votes297 views2 answers
Oracle list columns
SQL
2 votes278 views2 answers
How to get capital letter first in sql
SQL
0 vote241 views0 answer
SQL
0 vote295 views1 answer
Alter check command
SQL