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.
SQL – MySQL SUBSTR() Function
The MySQL SUBSTR() function extracts a substring from a string, starting from any position.
SQL – MySQL SUBSTRING() Function
The MySQL SUBSTRING() function extracts a substring from a string, starting from any position.
SQL – MySQL SUBSTRING_INDEX() Function
The MySQL SUBSTRING_INDEX() function returns a substring of a string before a specified number of delimiter occurs.
SQL – MySQL SUBTIME() Function
The MySQL SUBTIME() function subtracts time from a time/datetime expression and then returns the new time/datetime.
SQL – MySQL SYSDATE() Function
The MySQL SYSDATE() function returns the current date and time as “YYYY-MM-DD HH:MM:SS” (string) or as YYYYMMDDHHMMSS (numeric).
SQL – MySQL SYSTEM_USER() Function
The MySQL SYSTEM_USER() function returns the current user name and host name for the MySQL connection.