Christopher Kings-Lynne writes:
> Another thing, why is there a funtional form of 'now' called now(), but not
> a functional form of 'today' called today()? (7.1.3)
Most of these are legacy and/or compatibility and/or convenience things.
'today' is now called CURRENT_DATE and 'now' is called CURRENT_TIMESTAMP,
plus or minus a type cast. The now() function is also there for ODBC
compliance. To make things worse, ODBC also adds (or should add)
CURDATE() and CURRENT_DATE() and other such redundant things.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter