Articles

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

How the DAY() function works in Mariadb?

The MariaDB DAY() function is used to extract the day of the month from a given date, returning an integer value between 1 and 31.

The GeomFromWKB() function is a spatial function that creates a geometry object from a well-known binary (WKB) representation.

The IS_IPV4_MAPPED() function is a network function that tests whether an IPv6 address is mapped to an IPv4 address or not.

The RLIKE operator in MariaDB is used to test whether a string matches a regular expression.

The MariaDB DATEDIFF() function is used to calculate the difference in days between two dates.

The GeomFromText() function is a spatial function that creates a geometry object from a well-known text (WKT) representation.

The IS_IPV4_COMPAT() function is a network function that tests whether an IPv6 address is compatible with an IPv4 address or not.

The RIGHT() function in MariaDB is a string function that returns a given number of characters from the rightmost part of a string.

The DATE() function is a built-in function in Mariadb that extracts the date part from a date or datetime value and returns it as a date value.

The GeometryType() function is a spatial function that returns the type of a geometry object as a string.