DATENAME Function - Sybase ASE to MariaDB Migration

In Sybase ASE you can use DATENAME function to extract the specified unit (a date part such as year, month, day etc.) from a datetime value. For month and weekday units the function returns a literal (January, Monday etc.), for other units it returns an integer number.

In MariaDB there is no single function with the same functionality, and you have to use YEAR(), MONTH(), DAY() and other functions to extract the required datetime units (date parts).

Sybase ASE:

  -- Get the name of week day
  SELECT DATENAME(dw, '2017-12-17')
  # Sunday

MariaDB:

  -- Get the name of week day
  SELECT DAYNAME('2017-12-17')
  # Sunday

You can use SQLines SQL Converter to convert Sybase ASE DATENAME function to MariaDB that maps the units to the appropriate datetime functions in MariaDB:

For more information, see:

• DATEPART Function
• Sybase ASE to MariaDB Migration