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.
SQL – MySQL TIME() Function
The MySQL TIME() function extracts the time part from a given time/datetime, and returns “00:00:00” if not a datetime/time, or NULL if expression is NULL.
SQL – MySQL TIME_FORMAT() Function
The MySQL TIME_FORMAT() function formats a time by a specified format.
SQL – MySQL TIME_TO_SEC() Function
The MySQL TIME_TO_SEC() function converts a time value into seconds.
SQL – MySQL TIMEDIFF() Function
The MySQL TIMEDIFF() function returns the difference between two time/datetime expressions (written in the same format).
SQL – MySQL TIMESTAMP() Function
The MySQL TIMESTAMP() function returns a datetime value based on a date or datetime value.
SQL – MySQL TO_DAYS() Function
The MySQL TO_DAYS() function returns the number of days between a date and year 0 (date “0000-00-00”).
SQL – MySQL TRIM() Function
The MySQL TRIM() function removes leading and trailing spaces from a string.
SQL – MySQL TRUNCATE() Function
The MySQL TRUNCATE() function truncates a number to the specified number of decimal places.
SQL – MySQL USER() Function
The MySQL USER() function returns the current user name and host name for the MySQL connection.
SQL – MySQL VERSION() Function
The MySQL VERSION() function returns the current version of the MySQL database, as a string.