DATEDIFF to TIMESTAMPDIFF - Sybase ASE to MariaDB Migration

In Sybase ASE you can use DATEDIFF function to get the difference between two datetime values in the specified interval units (days, hours, minutes etc.). In MariaDB you can use TIMESTAMPDIFF function, but note that the interval unit specifiers can be different:

Sybase ASE:

  -- Get difference in days between two datetimes
  SELECT DATEDIFF(dd, '2017-12-16', '2017-12-31')
  # 15

MariaDB:

  -- Get difference in days between two datetimes
  SELECT TIMESTAMPDIFF(day, '2017-12-16', '2017-12-31');
  # 15

You can use SQLines SQL Converter to convert Sybase ASE DATEDIFF function to TIMESTAMPDIFF that maps the interval units to the appropriate values in MariaDB:

Sybase ASE			MariaDB
yy	year	Difference in years	year
qq	quarter	Difference in quarters	quarter
mm	month	Difference in months	month
wk	week	Difference in weeks	week
dd	day	Difference in days	day
hh	hour	Difference in hours	hour
mi	minute	Difference in minutes	minute
ss	second	Difference in seconds	second
ms	millisecond	Difference in milliseconds	1/1000 microsecond
us	microsecond	Difference in microseconds	microsecond

Conversion examples:

For more information, see:

• Sybase ASE DATEADD to MariaDB TIMESTAMPADD Conversion
• Sybase ASE to MariaDB Migration