MySQL Functions

This is an alphabetical listing of our documentation of MySQL functions. This is provided as a quick way to get to the documentation page when you know which function you need information on. The more popular functions are highlighted with blue text for the heading.

This MySQL function returns the absolute value of a given number.
page views: 2,976;
category: Математические функции
EXPORT_SET( )
This MySQL function returns a series of strings in order that represent each bit of a given number.
page views: 2,870;
category: Строковые функции
RADIANS( )
This MySQL function converts degrees to radians.
page views: 2,764;
category: Математические функции
ACOS( )
This MySQL function returns the arccosine, in radians, of a given number.
page views: 2,660;
category: Математические функции
This MySQL function extracts date or time information from a date or a datetime expression in the format type requested.
page views: 3,825;
category: время и дата
This MySQL function returns a random floating-point number from 0 to 1.
page views: 3,072;
category: Математические функции
This MySQL function returns the arccosine, in radians, of a given number.
page views: 3,078;
category: Математические функции
FIELD( )
This MySQL function searches for the first string given in the following list of strings and returns the numeric position of the first string in the list that matches.
page views: 2,855;
category: Строковые функции
Эта функция MySQL реализует блокировку,созданную мощью GET_LOCK ().
This MySQL function can be used to add a given interval of time to a date or the value of a date column
page views: 3,204;
category: время и дата
This MySQL function returns the location of the first argument within a comma-separated list that is passed as a single stringin the second argument.
page views: 7,500;
category: Строковые функции
This MySQL function returns the string given in the first argument of the function, as many times as specified in the second argument.
page views: 3,649;
category: Строковые функции
Similar to ADDDATE(), but specifically and supposedly for adding time to a value. However, both MySQL functions allow the addition of date and time to a value.
page views: 4,495;
category: время и дата
This MySQL function rounds a given floating-point number down to the next lower integer.
page views: 3,139;
category: Математические функции
This MySQL function goes through the first argument and returns a string in which every occurrence of the second argument is replaced with third argument.
page views: 3,591;
category: Строковые функции
Эта функция MySQL расшифровывает текст, который был зашифрован с помощью алгоритма AES с ключом длиной 128-бит , обращающего AES_ENCRYPT () функцию.
This MySQL function returns the given floating-point number with a comma inserted between every three digits and a period before the number of decimal places specified in the second argument
page views: 3,621;
category: Математические функции
This MySQL function returns the characters of string in reverse order.
page views: 3,176;
category: Строковые функции
AES_ENCRYPT( )
Эта функция MySQL шифрует строку, используя алгоритм AES с 128-битным ключом. Он блокирует зашифрованную строку с паролем, данным в качестве второго аргумента.
Use this MySQL function in conjunction with the SQL_CALC_FOUND_ROWS option of a SELECT statement to determine the number of rows an SQL statement using a LIMIT clause wou
page views: 3,826;
category: Другие функции
This MySQL function returns the final length characters from a string.
page views: 3,807;
category: Строковые функции
ANALYSE( )
This MySQL function returns an analysis of a results table from a SELECT statement.
page views: 2,928;
category: Другие функции
This MySQL function returns the date based on the number of days given, which are from the beginning of the currently used standard calendar.
page views: 5,213;
category: время и дата
ROUND( )
This MySQL function rounds a number given in the first argument to the nearest integer.
page views: 2,919;
category: Математические функции
This MySQL function returns the numeric code corresponding to the first character of a given string.
page views: 3,243;
category: Строковые функции
This MySQL function returns the date based on Unix time, which is the number of seconds since January 1, 1970, Greenwich Mean Time (GMT).
page views: 4,796;
category: время и дата
This MySQL function returns the number of rows changed by the previous SQL statement.
page views: 3,871;
category: Другие функции
ASIN( )
This MySQL function returns the arcsine, in radians, of a given number.
page views: 2,715;
category: Математические функции
This MySQL function returns the format for a given data type, based on the standard given as the second argument.
page views: 3,692;
category: время и дата
This MySQL function adds padding to the right end of string, stopping if the combination of string and the added padding reach length characters.
page views: 3,743;
category: Строковые функции
ASIN( )
This MySQL function returns the arcsine, in radians, of a given number.
page views: 2,970;
category: Математические функции
Эта функция MySQL пытается получить блокировку на имя, данное в первом аргументе.
RTRIM( )
This MySQL function returns the given string with any trailing spaces removed.
page views: 2,916;
category: Строковые функции
ATAN( )
This MySQL function returns the arctangent, in radians, of a given number.
page views: 2,902;
category: Математические функции
GREATEST( )
This MySQL function compares two or more values, returning the greatest value.
page views: 2,949;
category: Математические функции
SCHEMA( )
This MySQL function returns the name of the database currently in use for the session.
page views: 2,789;
category: Другие функции
This MySQL function returns the arctangent, in radians, of X and Y for a point on a Cartesian plane.
page views: 2,996;
category: Математические функции
This MySQL function returns non-NULL values of a group concatenated by a GROUP BY clause, separated by commas.
page views: 3,849;
category: Статистические функции
This MySQL function returns the seconds value (0-59) for a given time.
page views: 3,667;
category: время и дата
This MySQL function returns the average or mean of a set of numbers given as the argument.
page views: 3,347;
category: Статистические функции
The first version of this MySQL function accepts a string and returns its numerical value, in hexadecimal, as it is represented in the underlying character set.
page views: 3,095;
category: Строковые функции
This MySQL function returns the period for a given number of seconds in the format hh:mm:ss.
page views: 8,038;
category: время и дата
BENCHMARK( )
Use this MySQL function to evaluate the performance of a MySQL server.
page views: 2,719;
category: Другие функции
This MySQL function returns the hour for a DATETIME or TIME column.
page views: 3,040;
category: время и дата
Эта функция MySQL возвращает имя пользователя и имя хоста для текущего соединения MySQL. Функция не принимает аргументов. Это синонимом SYSTEM_USER () и USER( ).
BIN( )
This MySQL function returns a binary number for a given integer.
page views: 2,851;
category: Строковые функции
This MySQL function returns the result given in the second argument if the condition given in the first argument is met (i.e., the condition does not equal 0 or NULL).
page views: 3,783;
category: Управление потоком
Эти нструкциии MySQL возвращают Secure Hash Algorithm (SHA) 160-битную контрольную сумму для данной строки. Результаты - строка, состоящая из 40 шестнадцатеричных цифр.
BINARY
Use this MySQL function to treat strings in their binary state.
page views: 2,854;
category: Строковые функции
This MySQL function returns the results of the condition given in the first argument of the function if its results are not NULL.
page views: 3,098;
category: Управление потоком
SIGN( )
This MySQL function returns -1 if the given number is a negative, 0 if it is zero, and 1 if it is positive.
page views: 2,805;
category: Математические функции
BIT_AND( )
This MySQL function returns the bitwise AND for all bits for the expression given. I'll confess here: I really have no idea what this does, although I wrote something about it.
page views: 2,962;
category: Статистические функции
This MySQL function converts an Internet Protocol (IP) address in dot-quad notation to its numeric equivalent.
page views: 3,846;
category: Математические функции
SIN( )
This MySQL function returns the sine of the number given, where number is expressed in radians.
page views: 2,967;
category: Математические функции
This MySQL function returns the number of bits set in the argument, which is an integer that the function treats as a binary number.
page views: 3,014;
category: Математические функции
This MySQL function converts the numeric equivalent of an IP address to its dot-quad notation.
page views: 3,764;
category: Математические функции
This MySQL function pauses the execution of an SQL statement in which it is given, for the number of seconds given.
page views: 12,927;
category: время и дата
BIT_LENGTH( )
This MySQL function returns the number of bits in a given string.
page views: 2,872;
category: Строковые функции
INSERT( )
This MySQL function inserts the string from the final argument into the string specified by the first argument, at the specified position.
page views: 2,751;
category: Строковые функции
This MySQL function returns the results of a classic algorithm that can be used to compare two similar strings.
page views: 3,130;
category: Строковые функции
This MySQL function returns the bitwise OR for all bits for the expression given. It calculates with a 64-bit precision (BIGINT).
page views: 3,297;
category: Статистические функции
This MySQL function returns the starting position of the first occurrence of the substring in the string given as the first argument.
page views: 3,241;
category: Строковые функции
SPACE( )
This MySQL function returns a string of spaces.
page views: 2,795;
category: Строковые функции
BIT_XOR( )
This MySQL function returns the bitwise XOR (exclusive or) for all bits for the expression given. It calculates with a 64-bit precision (BIGINT).
page views: 2,911;
category: Статистические функции
This MySQL function returns the position where search_value would be located in a comma-separated list of ordered_value arguments.
page views: 3,057;
category: Строковые функции
This MySQL function returns the square root of its input, which must be a positive number.
page views: 3,239;
category: Математические функции
CASE
This MySQL function produces results that vary based on which condition is true. It is similar to the IF( ) function except that multiple conditions and results may be strung together.
page views: 2,861;
category: Управление потоком
Use this MySQL function to determine whether the value of the argument given in parentheses is NULL. It returns 1 if the value is NULL and 0 if it is not NULL.
page views: 3,586;
category: Управление потоком
This MySQL function returns the population standard deviation of the given column.
page views: 3,083;
category: Статистические функции
Use this MySQL function to convert a value from one datatype to another.
page views: 2,982;
category: Строковые функции
Use this MySQL function to determine whether the name of the lock given in parentheses is free and available as a lock name.
This MySQL function returns the population standard deviation of the given column.
page views: 3,014;
category: Статистические функции
This MySQL function rounds a given floating-point number up to the next higher integer.
page views: 3,233;
category: Математические функции
Эта функция определяет, будет ли уже данное имя использоваться в качестве имени блокировки.
This MySQL function returns the population standard deviation of the given column.
page views: 3,273;
category: Статистические функции
CEILING( )
This MySQL function rounds a given floating-point number up to the next higher integer.
page views: 2,747;
category: Математические функции
This MySQL function returns the date of the last day of the month for a given date or datetime value.
page views: 12,245;
category: время и дата
This MySQL function returns the sample standard deviation of the given column.
page views: 3,228;
category: Статистические функции
This MySQL function returns a string corresponding to the numeric code passed as the argument.
page views: 3,193;
category: Строковые функции
This MySQL function converts a string given to all lowercase letters.
page views: 3,680;
category: Строковые функции
This MySQL function compares two strings to determine whether the first string is before or after the second string in ASCII sequence.
page views: 6,090;
category: Строковые функции
CHARACTER_LENGTH( )
This MySQL function returns the number of characters of a given string.
page views: 2,866;
category: Строковые функции
LEAST( )
Use this MySQL function to compare two or more values and return the smallest value.
page views: 2,843;
category: Математические функции
This MySQL function returns the date and time of a given string for a given format.
page views: 3,307;
category: время и дата
CHARSET( )
This MySQL function returns the character set used by a given string.
page views: 2,657;
category: Строковые функции
This MySQL function returns the first length characters from a string.
page views: 3,757;
category: Строковые функции
Use this MySQL function to subtract a date or time interval from the results of a DATE or TIME data type column. It's an alias for DATE_SUB( ).
page views: 3,930;
category: время и дата
This MySQL function returns the number of characters in a given string.
page views: 5,275;
category: Строковые функции
LENGTH( )
This MySQL function returns the number of bytes contained in a given string.
page views: 2,774;
category: Строковые функции
This MySQL function is an alias of SUBSTRING().
page views: 3,052;
category: Строковые функции
This MySQL function returns the leftmost non-NULL string or column in a comma-separated list.
page views: 3,067;
category: Строковые функции
LN( )
This MySQL function returns the natural logarithm of its input.
page views: 2,875;
category: Математические функции
This MySQL function returns the characters of a given string, starting from the position given.
page views: 3,809;
category: Строковые функции
This MySQL function returns an arbirary value known as the coercibility of a given string or other item, determning how likely that item is to determine the collation used in
page views: 3,221;
category: Строковые функции
This MySQL function reads the contents of a file and returns it as a string that may be used in MySQL statements and functions.
page views: 3,253;
category: Строковые функции
This MySQL function returns a substring of string, using delimiter to separate substrings and count to determine which of the substrings to return.
page views: 4,432;
category: Строковые функции
COLLATION( )
This MySQL function returns the collation for the character set of a given string.
page views: 2,733;
category: Строковые функции
This MySQL function returns the current system date in yyyy-mm-dd hh:mm:ss format. It's synonymous with LOCALTIMESTAMP( ) and NOW( ).
page views: 2,987;
category: время и дата
This MySQL function returns the date and time for the given string or column, decreased by the time given as the second argument (d hh:mm:ss).
page views: 7,922;
category: время и дата
COMPRESS( )
This MySQL function returns a given string after compressing it.
page views: 2,796;
category: Строковые функции
LOCALTIMESTAMP( )
This MySQL function is synonymous with LOCALTIME( ) and NOW( ).
page views: 2,916;
category: время и дата
This MySQL function returns the sum of the values for the given column or expression.
page views: 3,230;
category: Статистические функции
With this MySQL function, strings or columns can be concatenated or pasted together into one resulting field.
page views: 5,438;
category: Строковые функции
This MySQL function returns the numeric starting point of the first occurrence of a substring in the string supplied as a second argument.
page views: 5,376;
category: Строковые функции
This MySQL function returns the system date in the yyyy-mm-dd hh:mm:ss format at the time it's executed.
page views: 6,656;
category: время и дата
CONNECTION_ID( )
Эта функция MySQL возвращает MySQL соединение или индикационный номер потока для сессии MySQL.
LOG( )
This MySQL function returns the logarithm of the first argument to the base indicated by the second argument.
page views: 2,933;
category: Математические функции
Эта функция MySQL возвращает имя пользователя и имя хоста для текущего соединения MySQL. Функция не принимает аргументов. Это синонимом SESSION_USER () и пользовательские ().
This MySQL function converts a number from one numeric base system to another.
page views: 3,002;
category: Математические функции
LOG10( )
This MySQL function returns the base 10 logarithm of a given number.
page views: 2,817;
category: Математические функции
This MySQL function returns the tangent of an angle, where number is expressed in radians.
page views: 3,038;
category: Математические функции
CONVERT( )
Use this MySQL function to convert the character set of a given string to another character set specified with the USING keyword.
page views: 2,790;
category: Строковые функции
LOG2( )
This MySQL function returns the base-two logarithm of a given number.
page views: 2,777;
category: Математические функции
This MySQL function returns the time from a given string or column containing date and time data.
page views: 3,226;
category: время и дата
This MySQL function converts a date and time for given time zone to another which is specified.
page views: 5,678;
category: время и дата
LOWER( )
This MySQL function converts a string given to all lowercase letters.
page views: 2,860;
category: Строковые функции
This MySQL function returns the time difference between the two times given.
page views: 3,344;
category: время и дата
COS( )
This MySQL function returns the cosine of number, where number is expressed in radians.
page views: 2,954;
category: Математические функции
This MySQL function adds padding to the left end of string, stopping if the combination of string and the added padding reach length characters.
page views: 3,973;
category: Строковые функции
TIMESTAMP( )
This MySQL function merges the date and time from given strings or columns that contain date and time data separately; the result is returned in yyyy-mm-dd hh:mm:ss format.
page views: 2,846;
category: время и дата
COT( )
This MySQL function returns the cotangent of a number.
page views: 2,835;
category: Математические функции
LTRIM( )
This MySQL function returns the given string with any leading spaces removed.
page views: 2,967;
category: Строковые функции
This MySQL function adds the given number of intervals of time to the given date or time.
page views: 7,766;
category: время и дата
This MySQL function returns the number of rows retrieved in the SELECT statement for the given column.
page views: 4,251;
category: Статистические функции
This MySQL function determines the date requested from the start of the given year, by adding the number of days given.
page views: 3,717;
category: время и дата
This MySQL function returns the time difference between the two times given, but only for the interval being compared.
page views: 4,977;
category: время и дата
CRC32( )
This MySQL function returns the given string's cyclic redundancy check value as a 32-bit unsigned value.
page views: 2,777;
category: Строковые функции
This MySQL function converts a given hour, minute, and second to hh:mm:ss format.
page views: 2,974;
category: время и дата
This MySQL function returns the time value of the time element provided and formats it according to formatting codes given.
page views: 3,658;
category: время и дата
This MySQL function returns the current system date in yyyy-mm-dd format.
page views: 4,581;
category: время и дата
This MySQL function converts the decimal number in bits to binary and returns a comma-separated list of values for all the bits that are set in that number, using string1 for the low-
page views: 3,495;
category: Строковые функции
This MySQL function returns the number of seconds that the given time represents.
page views: 5,222;
category: время и дата
This MySQL function is the same as CURDATE().
page views: 3,095;
category: время и дата
This MySQL function is used only for columns indexed by a FULLTEXT index, and only in WHERE clauses.
page views: 3,346;
category: Строковые функции
This MySQL function returns the date based on the number of days given, which are from the beginning of the currently used standard calendar.
page views: 3,168;
category: время и дата
This MySQL function returns the current time in hh:mm:ss format. This is synonymous with CURTIME( ).
page views: 2,999;
category: время и дата
MAX( )
This MySQL function returns the highest number in the values for a given column.
page views: 2,936;
category: Статистические функции
This MySQL function returns the given string with any trailing or leading padding removed, depending on which is specified.
page views: 12,897;
category: Строковые функции
This MySQL function returns the current date and time in yyyy-mm-dd hh:mm:ss format.
page views: 3,178;
category: время и дата
Эта функция MySQL использует MD5 128-битную контрольную сумму для возврата 32-символьного хэш-значения строки из RFC 1321.
TRUNCATE( )
This MySQL function returns a number equivalent to its first argument, removing any digits beyond the number of decimal places specified in the second argument.
page views: 2,791;
category: Математические функции
CURRENT_USER( )
Эта функция MySQL возвращает имя пользователя и хост, которые были даны пользователем для текущего соединения MySQL. Это не всегда может вернуть те же результаты как USER ().
This MySQL function extracts the microseconds value of a given time.
page views: 4,285;
category: время и дата
This MySQL function converts a string given to all uppercase letters.
page views: 3,738;
category: Строковые функции
This MySQL function returns the current system time in hh:mm:ss format.
page views: 3,699;
category: время и дата
This MySQL function returns the characters of a given string, starting from the position specified in the second argument.
page views: 3,744;
category: Строковые функции
UNCOMPRESS( )
This MySQL function returns the uncompressed string corresponding to the compressed string given, reversing the results of the COMPRESS( ) function.
page views: 2,899;
category: Строковые функции
DATABASE( )
This MySQL function returns the name of the database currently in use for the session.
page views: 2,815;
category: Другие функции
MIN( )
This MySQL function returns the lowest number in the values for a given column.
page views: 2,943;
category: Статистические функции
UNCOMPRESSED_LENGTH( )
This MySQL function returns the number of characters contained in the given compressed string before it was compressed.
page views: 2,538;
category: Строковые функции
DATE( )
This MySQL function returns the date from a given string, value, or expression that is submitted in a date or datetime format.
page views: 2,957;
category: время и дата
This MySQL function returns the minute value (0-59) of a given time.
page views: 3,963;
category: время и дата
This MySQL function converts hexadecimal numbers to their character equivalents.
page views: 3,965;
category: Строковые функции
This MySQL function returns the number of days of difference between the two dates given.
page views: 3,202;
category: время и дата
MOD( )
This MySQL function returns the remainder of a number given in the first argument when divided by the number given in the second argument, the modulo.
page views: 2,870;
category: Математические функции
UNIX_TIMESTAMP( )
This MySQL function returns the number of seconds since the start of the Unix epoch (January 1, 1970, Greenwich Mean Time).
page views: 2,918;
category: время и дата
Using the date or datetime given, this MySQL function adds the number of intervals specified. It's fairly synonymous with the ADDDATE( ) function.
page views: 6,165;
category: время и дата
This MySQL function returns the numeric value of the month (0-12) for the date provided.
page views: 3,939;
category: время и дата
UPPER( )
This MySQL function converts a given string to all uppercase letters.
page views: 2,945;
category: Строковые функции
This MySQL function returns a date and time in a desired format, based on formatting codes listed within quotes for the second argument of the function.
page views: 4,683;
category: время и дата
This MySQL function returns the name of the month for the date provided.
page views: 6,085;
category: время и дата
USER( )
Эта функция MySQL возвращает имя пользователя и имя хоста для текущего соединения MySQL. Функция не принимает аргументов. Это синонимом SESSION_USER () и SYSTEM_USER ().
Use this MySQL function to subtract from the results of a date or time data type column. It's fairly synonymous with the SUBDATE( ).
page views: 4,610;
category: время и дата
This MySQL function returns the current date and time. The format returned is yyyy-mm-dd hh:mm:ss.nnnnnn. It's synonymous with LOCALTIME( ) and LOCALTIMESTAMP( ).
page views: 3,947;
category: время и дата
This MySQL function returns the current Universal Time, Coordinated (UTC) date in yyyy-mm-dd format.
page views: 3,119;
category: время и дата
DAY( )
This MySQL function returns the day of the month for a given date.
page views: 2,929;
category: время и дата
This MySQL function returns NULL if the two arguments given are equal. Otherwise, it returns the value or results of the first argument.
page views: 3,007;
category: Управление потоком
This MySQL function returns the current Universal Time, Coordinated (UTC) time in hh:mm:ss format.
page views: 3,035;
category: время и дата
This MySQL function returns the name of the day for the date provided.
page views: 4,052;
category: время и дата
OCT( )
This MySQL function returns the octal or base 8 numeric system value of the given number.
page views: 2,967;
category: Математические функции
This MySQL function returns the current UTC date and time in yyyy-mm-dd hh:mm:ss format.
page views: 4,953;
category: время и дата
This MySQL function returns the day of the month for the date given.
page views: 3,956;
category: время и дата
OCTET_LENGTH( )
This MySQL function returns the number of bytes contained in the given string.
page views: 2,865;
category: Строковые функции
UUID ( )
This MySQL function returns a Universal Unique Identifier (UUID), a 128-bit number composed of five hexadecimal numbers.
page views: 2,924;
category: Другие функции
This MySQL function returns the numerical day of the week for a given date.
page views: 3,935;
category: время и дата
OLD_PASSWORD( )
Эта функция MySQL шифрует данную строку на основе метода шифрования паролей, использовавшегося до версии 4.1 MySQL. Результат не может быть расшифрован.
With this MySQL function the variance is determined by taking the difference between each given value and the average of all values given.
page views: 5,916;
category: Статистические функции
This MySQL function returns the day of the year. January 1 would give a value of 1.
page views: 3,026;
category: время и дата
This MySQL function returns an ordinal value, the position of a character in the ASCII character set of the left-most character in a given string.
page views: 3,292;
category: Строковые функции
This MySQL function returns the variance of a given column, based on the rows selected as a population.
page views: 3,287;
category: Статистические функции
Эта функция MySQL расшифровывает данную строку, зашифрованную с заданным паролем. См. также ENCODE( )функции.
Эта функция MySQL шифрует пароль, выданный в качестве аргумента. В результате не может быть расшифрован.
This MySQL function returns the variance of a given column, based on the rows selected as a sample of a given population.
page views: 2,974;
category: Статистические функции
DEGREES( )
This MySQL function converts radians to degrees.
page views: 2,741;
category: Математические функции
This MySQL function adds a specified number of months to a period, which is a string containing only the year and month in either yyyymm or yymm format.
page views: 3,148;
category: время и дата
VERSION( )
This MySQL function returns the MySQL server version.
page views: 2,807;
category: Другие функции
Эта функция MySQL расшифровывает текст, который был зашифрован с помощью тройного DES алгоритма с 128-битным ключом длиной, обращающего DES_ENCRYPT () функцию.
This MySQL function returns the number of months between periods given.
page views: 3,706;
category: время и дата
This MySQL function returns the number of the week starting from the beginning of the year for the date provided.
page views: 4,401;
category: время и дата
Эта функция MySQL возвращает зашифрованный текст, используя алгоритм тройного DES с ключом длиной 128-бит.
PI( )
This MySQL function returns by default the first five decimal places of the number pi.
page views: 2,806;
category: Математические функции
This MySQL function returns the number for the day of the week. Monday is considered the first day of the week.
page views: 3,218;
category: время и дата
This MySQL function returns the index element from the list of strings given, where the list is numbered starting with 1.
page views: 2,974;
category: Строковые функции
POSITION( )
This MySQL function returns index of the character in string where substring first appears.
page views: 2,654;
category: Строковые функции
WEEKOFYEAR( )
This MySQL function returns the calendar week of the year for a given date. It's a bit synonymous with WEEK( ).
page views: 2,865;
category: время и дата
Эта функция MySQL шифрует заданную строку в двоичном формате и запирает его с паролем. Вы не должны использовать эту функцию для пароля колонки в таблице пользователей базы данных MySQL.
POW( )
This MySQL function returns the result of raising the number given in the first argument to the exponent given in the second argument.
page views: 2,905;
category: Математические функции
This MySQL function returns the year of the date provided.
page views: 3,551;
category: время и дата
ENCRYPT( )
Эта функция MySQL возвращает зашифрованный текст с помощью языка C-language crypt функции.
POWER( )
This MySQL function returns the result of raising the number given in the first argument to the power of the number given in the second argument.
page views: 2,858;
category: Математические функции
This MySQL function returns the year coupled with the number of the week into the year: yyyyww. By default, the first day of the week is Sunday and the basis of the calculation.
page views: 3,518;
category: время и дата
EXP( )
This MySQL function returns the value of the natural logarithm base number e to the power of the given number.
page views: 2,888;
category: Математические функции
This MySQL function returns the number of the quarter (1-4) for the date provided. The first quarter (i.e., three months) of each year has a value of 1.
page views: 6,660;
category: время и дата