framework/resources/Functional/datetime/sql_to_date_1.q

select sql_to_date('05Dec2016', 'ddmonyyyy'),sql_to_date('05Dec2016', 'DDMONYYY'),sql_to_date('2016-09-22','yyyy-mm-dd') from (values(1));