Table of Contents
Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle To_timestamp function to HiRDB
To_timestamp function without nls_parameters
HiRDB database doesn't support TO_TIMESTAMP function without nls_parameters. SQLWays changes it to equivalent function timestamp_format.
Oracle:
SELECT TO_TIMESTAMP('10-Sep-02 14:10:10.123000', 'DD-Mon-RR HH24:MI:SS.FF') FROM t;
HiRDB:
SELECT timestamp_format ('10-Sep-02 14:10:10.123000', 'DD-Mon-RR HH:MI:SS.FF') FROM t;
To_timestamp function with nls_parameters
HiRDB hasn't equivalent for To_timestamp function with nls_parameters. SQLWays leaves it as is and adds message /*Сould not convert ' TO_TIMESTAMP '*/.
Oracle:
SELECT TO_TIMESTAMP ('10-Sep-02 14:10:10.123000', 'DD-Mon-RR HH24:MI:SS.FF' ,'NLS_DATE_LANGUAGE = American') FROM t;
HiRDB:
SELECT TO_TIMESTAMP ('10-Sep-02 14:10:10.123000', 'DD-Mon-RR HH24:MI:SS.FF' ,'NLS_DATE_LANGUAGE = American') FROM t;
/*Сould not convert ' TO_TIMESTAMP '*/