A constant keyword
Format
SQL Format:
{ CURRENT_DATE | TRUE | FALSE | NULL } |
{ CURRENT_TIME | CURRENT_TIMESTAMP } [ ( Precision ) ]
ODBC Format:
{{ FN { CURRENT_DATE | CURDATE | CURTIME | NOW } [ ( ) ] }} |
{{ FN { CURRENT_TIME | CURRENT_TIMESTAMP } ( Precision ) }}
Remarks
Keywords that specify a constant value. Where Precision is an integer literal.
| Keyword | Description |
|---|---|
| CURRENT_DATE | Returns the current date |
| CURRENT_TIME | Returns the current time |
| CURRENT_TIMESTAMP | Returns the current date and time |
| CURDATE | Returns the current date |
| CURTIME | Returns the current time |
| NOW | Returns the current date and time |