DATENAME Function - SQL Server to Oracle Migration

In Microsoft SQL Server you can use DATENAME function to extract the specified unit (a date part such as year, month, day etc.) from a datetime value. In Oracle 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

Oracle:

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

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

For more information, see SQL Server to Oracle Migration.