https://sqlines.com/ 2026-04-26T01:31:20+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2026-01-15T14:24:48+00:00 https://sqlines.com/mysql-to-mariadb/regexp_substr?rev=1768487088&do=diff In MySQL and MariaDB, the REGEXP_SUBSTR function returns the substring that matches the regular expression. MySQL's REGEXP_SUBSTR allows specifying four parameters, including the starting position and the Nth occurrence, while MariaDB's REGEXP_SUBSTR allows specifying only two parameters. text/html 2025-12-24T21:35:19+00:00 https://sqlines.com/mysql-to-mariadb/time_to_sec?rev=1766612119&do=diff In MySQL and MariaDB, the TIME_TO_SEC function converts a time value to the number of seconds past midnight. However, in MySQL it returns an integer value, whereas in MariaDB it returns a double. MySQL: -- Get seconds past midnight SELECT TIME_TO_SEC('12:16:46.123456'); /* 44206 */