The CURRENT_DATE Function
Syntax for the CURRENT_DATE function:
- The result is the current date (i.e. "today") as a DATE value.
- In any given SQL statement, all references to CURRENT_DATE are effectively evaluated simultaneously from a single reading of the server clock. Thus the conditional expression CURRENT_DATE = CURRENT_DATE is guaranteed to always evaluate to true.
- In any given SQL statement, the value of CURRENT_DATE will always be equal to the DATE portion of LOCALTIMESTAMP.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40