Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle CURRENT_TIMESTAMP function to HiRDB
HiRDB database supports CURRENT_TIMESTAMP function. SQLWays leaves CURRENT_TIMESTAMP without precision as is.
CURRENT_TIMESTAMP(precision) converted according rules:
-if precision >= 6 , converted to CURRENT_TIMESTAMP(6)
-if precision is odd number, converted to CURRENT_TIMESTAMP(precision + 1)
Oracle:
select CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(3), CURRENT_TIMESTAMP(12) from t;
HiRDB:
select CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(4), CURRENT_TIMESTAMP(6) from t;
References in Wiki
Database | Reference |
---|---|
Oracle | CURRENT_TIMESTAMP |
HiRDB | CURRENT_TIMESTAMP |