https://www.sqlines.com/ 2026-04-18T08:31:32+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2017-11-26T09:23:56+00:00 https://www.sqlines.com/sybase-to-mariadb/concat?rev=1511688236&do=diff In Sybase ASE you can use the string concatenation operator + to concatenate two or more string values. If any value is NULL the operator treats it as an empty string: Sybase ASE: SELECT 'a' + 'b'; -- Result: 'ab' SELECT NULL + 'a' + 'b'; -- Result: 'ab' text/html 2017-12-16T08:28:50+00:00 https://www.sqlines.com/sybase-to-mariadb/convert_datetime_to_string?rev=1513412930&do=diff In Sybase ASE you can use CONVERT function to convert a DATETIME value to a string with the specified format. In MariaDB, you can use DATE_FORMAT function: Sybase ASE: -- 3rd parameter specifies 140 style ('YYYY-MM-DD HH:MI:SS.FFFFFF' format with microseconds) SELECT CONVERT(VARCHAR, GETDATE(), 140); # 2017-12-14 18:40:41.063000 text/html 2017-12-16T08:29:02+00:00 https://www.sqlines.com/sybase-to-mariadb/convert_string_to_datetime?rev=1513412942&do=diff In Sybase ASE you can use CONVERT function to convert a string value in the specified format to DATETIME. In MariaDB you can use STR_TO_DATE function: Sybase ASE: -- 3rd parameter specifies 16 style (mon dd yyyy hh24:mm:ss) SELECT CONVERT(DATETIME, 'Dec 14 2017 18:48:13', 16); text/html 2017-12-16T19:20:53+00:00 https://www.sqlines.com/sybase-to-mariadb/dateadd?rev=1513452053&do=diff In Sybase ASE you can use DATEADD function to add an interval to the datetime value. In MariaDB you can use TIMESTAMPADD function, but note that the interval unit specifiers can be different: Sybase ASE: -- Add 1 day to the current datetime SELECT DATEADD(dd, 1, GETDATE()) # 2017-12-17 10:38:11.343 -- Subtract 1 day from the current datetime SELECT DATEADD(dd, -1, GETDATE()) # 2017-12-15 10:38:11.343 text/html 2017-12-16T19:19:38+00:00 https://www.sqlines.com/sybase-to-mariadb/datediff?rev=1513451978&do=diff 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: text/html 2017-12-17T17:32:21+00:00 https://www.sqlines.com/sybase-to-mariadb/datename?rev=1513531941&do=diff 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. text/html 2017-12-17T17:31:41+00:00 https://www.sqlines.com/sybase-to-mariadb/datepart?rev=1513531901&do=diff In Sybase ASE you can use DATEPART function to extract the integer part of the specified unit (a date part such as year, month, day etc.) from a datetime value. 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). text/html 2017-12-08T21:51:21+00:00 https://www.sqlines.com/sybase-to-mariadb/declare_cursor?rev=1512769881&do=diff You can use DECLARE CURSOR statement to declare a cursor in both Sybase ASE and MariaDB. But Sybase ASE allows you to put DECLARE statements everywhere in the code while MariaDB requires cursor declarations to be specified after the variable declarations and before any DML statement. text/html 2017-09-14T07:51:35+00:00 https://www.sqlines.com/sybase-to-mariadb/identity?rev=1505375495&do=diff In Sybase ASE you can use IDENTITY column property to automatically generate unique values for the column, for example, to generate IDs. In MariaDB you can use AUTO_INCREMENT column property but there are some issues that you have to take into account during the conversion from Sybase to MariaDB. text/html 2017-12-14T14:40:02+00:00 https://www.sqlines.com/sybase-to-mariadb/len?rev=1513262402&do=diff In Sybase ASE you can use the LEN function to get the number of characters in the string. Note that LEN includes the trailing spaces (although the Sybase ASE SQL reference states otherwise), and returns 1 as the length of empty string. '' This also applies to Sybase ASE CHAR_LENGTH function. text/html 2025-05-07T13:41:22+00:00 https://www.sqlines.com/sybase-to-mariadb/single_double_quotes?rev=1746625282&do=diff In Sybase ASE and MariaDB, by default you can simultaneously use both single '' and double "" quotes for string literals. Sybase ASE: -- Use single and double quotes for strings SELECT "abc", 'abc'; MariaDB: -- Use single and double quotes for strings SELECT "abc", 'abc'; text/html 2025-07-13T07:27:43+00:00 https://www.sqlines.com/sybase-to-mariadb/substring?rev=1752391663&do=diff In Sybase ASE, the SUBSTRING function returns a substring from a string, starting at the specified position and for the specified length. SUBSTRING always takes three arguments. In MariaDB, you can also use the SUBSTRING function. Sybase ASE: -- Get first 3 characters SELECT SUBSTRING('New York', 1, 3); /* New */