DATEPART Function - Sybase ASE to Oracle Migration

In SAP Sybase Adaptive Server Enterprise (ASE) you can use the DATEPART function to extract the specified unit (a date part such as year, month, day etc.) from a datetime value as integer.

In Oracle you can use an expression with TO_NUMBER and TO_CHAR functions with the specific format type. Note that DATEPART units differ from TO_CHAR format models.

Sybase ASE:

  -- Get the day part
  SELECT DATEPART(dd, '2026-07-14');
  /* 14 */

Oracle:

  -- Get the day part
  SELECT TO_NUMBER(TO_CHAR(DATE '2026-07-14', 'dd')) FROM dual;
  /* 14 */

You can map Sybase ASE DATEPART units to the appropriate TO_CHAR format models in Oracle as follows:

For more information, see Sybase ASE to Oracle Migration.