I used to know SELECT TO_DATE ('2001-02-16', 'YYYY-MM-DD') from DUAL
I can see it today to write SELECT DATE '2001-02-16' from Dual.
Return is a collection of Date types
Similar to SELECT TIMESTAMP '2004-01-31 11:20:11' from dual