TIMESTAMP Data Type - PostgreSQL to Oracle Migration

In both PostgreSQL and Oracle, the TIMESTAMP data type stores date and time data (year, month, day, hour, minute, second and fractional second).

PostgreSQL and Oracle:

  -- A sample table
  CREATE TABLE product
  (
     name VARCHAR(70),
     created TIMESTAMP(3),
     expiry TIMESTAMP
  );

Conversion Overview

TIMESTAMP conversion issues:

PostgreSQL Oracle
Syntax TIMESTAMP[(p)] TIMESTAMP[(p)]
Range 0 ⇐ p ⇐ 6 0 ⇐ p ⇐ 9
Default p is 6 p is 6

Database and SQL Migration Tools

About SQLines

SQLines offers services and tools to help you migrate databases and applications. For more information, please contact us at support@sqlines.com.

You could leave a comment if you were logged in.