CONVERT - String to Datetime - Sybase ASE to PostgreSQL Migration

In Sybase Adaptive Server Enterprise (ASE) you can use CONVERT function to convert a string expression in the specified format (style) to a datetime data type (DATE, DATETIME etc.). In PostgreSQL you can to use TO_TIMESTAMP function.

Note that Sybase ASE CONVERT and PostgreSQL formats are different.

Sybase ASE:

  -- Convert string to datetime
  SELECT CONVERT(DATETIME, '12/28/2022 11:13:31', 110); 
  # 2022-12-28 11:13:31 AM

PostgreSQL:

  -- Convert string to datetime
  SELECT TO_TIMESTAMP('12/28/2022 11:13:31', 'MM/DD/YYYY HH24:MI:SS'); 
  # 2022-12-28 11:13:31+03

When you convert CONVERT function to TO_TIMESTAMP you have to map the Sybase ASE style to the appropriate format string in PostgreSQL:

Conversion examples:

For more information, see Sybase ASE to PostgreSQL Migration.