Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the FROM_UNIXTIME() function works in Mariadb?

The FROM_UNIXTIME() function is a date and time function that converts a Unix timestamp to a datetime value.

How the INET_ATON() function works in Mariadb?

The INET_ATON() function is a string function that converts an IPv4 address in dotted-quad notation to a numeric value.

How the CURRENT_DATE() function works in Mariadb?

The MariaDB CURRENT_DATE() function is used to retrieve the current date as a value in ‘YYYY-MM-DD’ or ‘YYYYMMDD’ format, depending on whether the function is used in a string or numeric context.

How the FROM_DAYS() function works in Mariadb?

The MariaDB FROM_DAYS() function is used to convert a day count (the number of days since the year 0) to a DATE value.

How the IN() operator works in Mariadb?

The IN operator is a logical operator that tests whether a value or an expression matches any value in a list of values.

How the CURDATE() function works in Mariadb?

The CURDATE() function is a date and time function that returns the current date as a value in YYYY-MM-DD format.

How the FROM_BASE64() function works in Mariadb?

The MariaDB FROM_BASE64() function is used to decode a string that is encoded using the base64 encoding scheme.

How the IFNULL() function works in Mariadb?

The IFNULL() function is a conditional function that returns the first argument if it is not NULL, otherwise it returns the second argument.

How the CUME_DIST() function works in Mariadb?

The MariaDB CUME_DIST() function is used to calculate the cumulative distribution of a value within a group of values.

How the FOUND_ROWS() function works in Mariadb?

The MariaDB FOUND_ROWS() function is used to retrieve the number of rows that would be returned by a SELECT statement, regardless of any LIMIT clause that may have been applied.