SQL CURDATE

SQL CURDATE is a MySQL function which returns current date based on server system.

Note: MySQL has 3 similar functions:
SQL NOW() : return date and time
SQL CURDATE: returns date
SQL CURTIME: returns time

SQL CURDATE() Syntax

SELECT CURDATE()

SQL CURDATE() Example

SELECT CURDATE()

The result will look like:
2011-09-25

SELECT NOW()
          , CURDATE()
          , CURTIME()

The result will look like: