DATENAME Function - SQL Server to PostgreSQL Migration

In Microsoft SQL Server (MS SQL) you can use DATENAME function to extract the specified unit (a date part such as year, month, day etc.) from a datetime value as string. In PostgreSQL you can use TO_CHAR function with the specific format type.

SQL Server:

  -- Get the name of week day
  SELECT DATENAME(dw, '2022-12-29')
  # Thursday

PostgreSQL:

  -- Get the name of week day
  SELECT TO_CHAR(DATE '2022-12-29', 'Day');
  # Thursday

You can map SQL Server DATENAME units to the appropriate TO_CHAR format in PostgreSQL as follows:

For more information, see SQL Server to PostgreSQL Migration.