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
  );

TIMESTAMP conversion issues:

• SQLines - Database and SQL Conversion Tool
• SQLines Data - Data Transfer and Database Schema Migration Tool
• Free Online SQL Conversion Tool

• PostgreSQL to Oracle Migration Reference

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