Built-In Function and Operator Reference Name Description Introduced Deprecated FORMAT_BYTES() Convert byte count to value with units 8.0.16 FORMAT_PICO_TIME() Convert time in picoseconds to value with units 8.0.16 FOUND_ROWS() For a SELECT with a LIMIT clause, the number of rows that would be returned were there no LIMIT clause FROM_BASE64() Decode base64 encoded string and return result FROM_DAYS() Convert a day number to a date FROM_UNIXTIME() Format Unix timestamp as a date GeomCollection() Construct geometry collection from geometries GeometryCollection() Construct geometry collection from geometries GET_DD_COLUMN_PRIVILEGES() Internal use only GET_DD_CREATE_OPTIONS() Internal use only GET_DD_INDEX_SUB_PART_LENGTH() Internal use only GET_FORMAT() Return a date format string GET_LOCK() Get a named lock GREATEST() Return the largest argument GROUP_CONCAT() Return a concatenated string GROUPING() Distinguish super- aggregate ROLLUP rows from regular rows GTID_SUBSET() Return true if all GTIDs in subset are also in set; otherwise false. GTID_SUBTRACT() Return all GTIDs in set that are not in subset. HEX() Hexadecimal representation of decimal or string value HOUR() Extract the hour 2100