SQL – MySQL CONNECTION_ID() Function
The MySQL CONNECTION_ID() function returns the unique connection ID for the current connection.
SQL – MySQL CONV() Function
The MySQL CONV() function converts a number from one numeric base system to another, and returns the result as a string value.
SQL – MySQL CONVERT() Function
The MySQL CONVERT() function converts a value into the specified datatype or character set.
SQL – MySQL COUNT() Function
The MySQL COUNT() function returns the number of records returned by a select query. NULL values are not counted.
SQL – MySQL CURDATE() Function
The MySQL CURDATE() function returns the current date as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
SQL – MySQL CURRENT_DATE() Function
The MySQL CURRENT_DATE() function returns the current date as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
SQL – MySQL CURRENT_TIME() Function
The MySQL CURRENT_TIME() function returns the current time as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
SQL – MySQL CURRENT_TIMESTAMP() Function
The MySQL CURRENT_TIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL CURRENT_USER() Function
The MySQL CURRENT_USER() function returns the user name and host name for the MySQL account that the server used to authenticate the current client.
SQL – MySQL CURTIME() Function
The MySQL CURTIME() function returns the current time as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
SQL – MySQL DATABASE() Function
The MySQL DATABASE() function returns the name of the current database. If there is no current database, this function returns NULL or “”.
SQL – MySQL DATE() Function
The MySQL DATE() function extracts the date part from a datetime expression.
SQL – MySQL DATEDIFF() Function
The MySQL DATEDIFF() function returns the number of days between two date values.
SQL – MySQL DATE_ADD() Function
The MySQL DATE_ADD() function adds a time/date interval to a date and then returns the date.
SQL – MySQL DATE_SUB() Function
The MySQL DATE_SUB() function subtracts a time/date interval from a date and then returns the date.
SQL – MySQL DAY() Function
The MySQL DAY() function returns the day of the month for a given date (a number from 1 to 31).
SQL – MySQL DAYNAME() Function
The MySQL DAYNAME() function returns the weekday name for a given date.