What is the DATE function? I found Rob van Wijk's SQL here
http://rwijk.blogspot.com/2007/10/sql-model-clause-tutorial-part-two.html

I can see it "works" (below), but does DATE have any parameters or is it influenced by NLS_DATE_FORMAT, or what?

SQL> select  date '2005-03-01' from dual;

DATE'2005-03-01'
-------------------
2005-03-01 00:00:00

DATE is such a non-unique key word that it's difficult to find in the documentation -- much like the TABLE() function!

Thanks!