Table of Contents
Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle To_date function to HiRDB
To_date function without nls_parameters
HiRDB has equivalent for To_date function without nls_parameters. SQLWays changes it to DATE function.
Oracle:
SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.') FROM t;
HiRDB:
SELECT DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.') FROM t;
To_date function with nls_parameters
HiRDB hasn't equivalent for To_date function with nls_parameters. SQLWays leaves it as is and adds message /*Сould not convert ' TO_DATE ' */.
Oracle:
SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = American') FROM t;
HiRDB:
SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M.', 'NLS_DATE_LANGUAGE = American') FROM t; /*Сould not convert ' TO_DATE '*/