hplsql/src/test/queries/local/to_timestamp.sql

TO_TIMESTAMP('2015-04-02', 'YYYY-MM-DD');
TO_TIMESTAMP('2015-04-02', 'yyyy-mm-dd');
TO_TIMESTAMP('04/02/2015', 'mm/dd/yyyy');

TO_TIMESTAMP('2015-04-02 13:51:31', 'YYYY-MM-DD HH24:MI:SS');