"Igal @ Lucee.org" <igal(at)lucee(dot)org> writes:
> How come `current_date` has no parenthesis but `clock_timestamp()` does?
Because the SQL standard says that CURRENT_DATE doesn't have parentheses.
It is a function by any other measure, though.
(AFAICT, the SQL committee is unacquainted with any principles of
programming language syntax design that emerged later than the COBOL
era. Their capacity to invent new and non-orthogonal syntax for every
new feature seems boundless.)
regards, tom lane