CURDATE
The function CURDATE returns the current date.
| SQL Syntax: |
CURDATE() | |
| Escape Syntax: |
{fn CURDATE()} | |
| Return Type: |
DATE | |
Examples:
SELECT curdate()SELECT {fn curdate()}, * FROM mytableSELECT * FROM mytable WHERE start < curdate()CREATE TABLE abc(
name varchar(30),
start date default curdate()
)
see also:
SQL Date Time Functions
NOW
CURTIME