DATETIME Data Type - SQL Server to PostgreSQL Migration

In SQL Server, DATETIME data type stores date and time with milliseconds accuracy. In PostgreSQL, you can use TIMESTAMP(3) data type.

SQL Server:

  -- Sample table with DATETIME with milliseconds accuracy
  CREATE TABLE specs
  (
    item VARCHAR(30),
    created_dt DATETIME
  );

PostgreSQL:

   -- Sample table with TIMESTAMP with milliseconds accuracy
  CREATE TABLE specs
  (
    item VARCHAR(30),
    created_dt TIMESTAMP(3)
  );

Conversion summary:

For more information, see SQL Server to PostgreSQL Migration.