SQL – MySQL QUARTER() Function
The MySQL QUARTER() function returns the quarter of the year for a given date value (a number from 1 to 4).
SQL – MySQL RADIANS() Function
The MySQL RADIANS() function converts a degree value (expressed as a positive or negative number) into radians.
SQL – MySQL RAND() Function
The MySQL RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
SQL – MySQL REPEAT() Function
The MySQL REPEAT() function repeats a string as many times as specified.
SQL – MySQL REPLACE() Function
The MySQL REPLACE() function replaces all case-sensitive occurrences of a substring within a string, with a new substring.
SQL – MySQL REVERSE() Function
The MySQL REVERSE() function reverses a string and returns the result.
SQL – MySQL RIGHT() Function
The MySQL RIGHT() function extracts a number of characters from a string, starting from right.
SQL – MySQL ROUND() Function
The MySQL ROUND() function rounds a number to a specified number of decimal places.
SQL – MySQL RPAD() Function
The MySQL RPAD() function right-pads a string with another string, to achieve a specified length.
SQL – MySQL SECOND() Function
The MySQL SECOND() function returns the seconds part of a time/datetime (from 0 to 59).
SQL – MySQL SEC_TO_TIME() Function
The MySQL SEC_TO_TIME() function returns a time value (in format HH:MM:SS) based on the specified seconds (positive or negative).
SQL – MySQL SESSION_USER() Function
The MySQL SESSION_USER() function returns the current user name and host name for the MySQL connection.
SQL – MySQL SPACE() Function
The MySQL SPACE() function returns a string of the specified number of space characters.
SQL – MySQL SQRT() Function
The MySQL SQRT() function returns the square root of a number greater than zero.
SQL – MySQL STR_TO_DATE() Function
The MySQL STR_TO_DATE() function returns a date based on a string and a format.
SQL – MySQL SUBDATE() Function
The MySQL SUBDATE() function subtracts a time/date interval from a date and then returns the new date.