Built-In Function and Operator Reference 2109 Name Description Introduced Deprecated ROUND() Round the argument ROW_COUNT() The number of rows updated ROW_NUMBER() Number of current row within its partition RPAD() Append string the specified number of times RTRIM() Remove trailing spaces SCHEMA() Synonym for DATABASE() SEC_TO_TIME() Converts seconds to ’hh:mm:ss’ format SECOND() Return the second (0-59) SESSION_USER() Synonym for USER() SHA1() ,  SHA() Calculate an SHA-1 160- bit checksum SHA2() Calculate an SHA-2 checksum SIGN() Return the sign of the argument SIN() Return the sine of the argument SLEEP() Sleep for a number of seconds SOUNDEX() Return a soundex string SOUNDS LIKE Compare sounds SPACE() Return a string of the specified number of spaces SQRT() Return the square root of the argument ST_Area() Return Polygon or MultiPolygon area ST_AsBinary() , ST_AsWKB() Convert from internal geometry format to WKB ST_AsGeoJSON() Generate GeoJSON object from geometry ST_AsText() , ST_AsWKT() Convert from internal geometry format to WKT ST_Buffer() Return geometry of points within given distance from geometry