CONVERT - Datetime to String - Sybase ASE to Oracle Migration

In Sybase Adaptive Server Enterprise (ASE) you can use CONVERT function to convert a DATETIME value to a string with the specified format. In Oracle you can use TO_CHAR function.

Note that Sybase ASE CONVERT and Oracle formats are different.

Sybase ASE:

  -- 3rd parameter specifies 121 style ('YYYY/MM/DD HH:MI:SS' format)
  SELECT CONVERT(VARCHAR, GETDATE(), 121);
  # 2022/12/27 14:33:49

Oracle:

  -- Specify string format using format specifiers
  SELECT TO_CHAR(SYSTIMESTAMP, 'YYYY/MM/DD HH24:MI:SS') FROM dual;
  # 2022/12/27 14:33:49

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

Conversion examples:

For more information, see Sybase ASE to Oracle Migration.