DAY Function - SQL Server to Oracle Migration

In SQL Server you can use DAY function to get the day (an integer number) of the specified datetime. In Oracle you have to use EXTRACT(DAY FROM datetime) function.

SQL Server:

  -- Get the day
  SELECT DAY('2022-12-28'); 
  # 28

Oracle:

  -- Get the day
  SELECT EXTRACT(DAY FROM DATE '2022-12-28') FROM dual; 
  # 28

For more information, see SQL Server to Oracle Migration.