Ana Iglesias (Universidad Politécnica de Madrid)
Thesaurus that gathers information of functions from MySQL
Adds a time/date interval to a date and then returns the date
Adds a time interval to a time/datetime and then returns the time/datetime
Returns the ASCII value for the specific character
Returns the arc tangent of one or two numbers
Returns the average value of an expression
Returns true if and only if the first parameter has a bit set in the position specified by the second parameter.
Returns the smallest integer value that is >= to a number
Returns the character that represents the ASCII value
Returns the length of a string (in characters)
Returns s1 without s2 (it s2 is in s1, else returns s1 as it was)
Compresses the data using the specified compression algorithm
Adds two or more expressions together with a separator
Checks if s2 is contained in s1 and returns a boolean
Returns the number of records returned by a select query
Extracts the date part from a datetime expression
Subtracts a time/date interval from a date and then returns the date
Returns the number of days between two date values
Returns the day of the month for a given date
Returns the weekday name for a given date
Returns the weekday index for a given date
Returns the day of the year for a given date
Returns the difference between the sounds of two strings
Checks if s1 ends with s2 and returns a boolean
Returns e raised to the power of a specified number
Expands data that was compressed using the COMPRESS function
Returns the index position of a value in a list of values
Attempts to find the next subsequence of the string that matches the pattern (maintains duplicates)
Returns the position of a string within a list of strings
Returns the largest integer value that is <= to a number
Checks if numerical value is greater than another
Returns the greatest value of the list of arguments
Calculate the hash value using an algorithm
and repeat this process for a number of iterations
Converts a hex representation of a string to a string
Returns a date changed by the given amount in the given unit of time. Unit defaults to 'hour'.
Inserts a string within a string at the specified position and for a certain number of characters
Returns the position of the first occurrence of a string in another string
Extracts the last day of the month for a given date
Returns the index fo s2 last ocurring in s1 as an integer, returns -1 if s2 is not found in s1
Returns the smallest value of the list of arguments
Extracts a number of characters from a string (starting from left)
Returns the length of a string (in bytes)
Checks if numerical value is less than another
Returns the natural logarithm of a number
Returns the position of the first occurrence of a substring in a string
or the logarithm of a number to a specified base
Returns the natural logarithm of a number to base 10
Returns the natural logarithm of a number to base 2
Creates and returns a date based on a year and a number of days value
Creates and returns a time based on an hour
Attempts to match the string in its entirety against the regex pattern and returns an array of capture groups (removes duplicates) - returning the first match
Returns the maximum value in a set of values
Returns the microsecond part of a time/datetime
Extracts a substring from a string (starting at any position)
Returns the minimum value in a set of values
Returns the minute part of a time/datetime
Returns the remainder of a number divided by another number
Returns the name of the month for a given date
and b is the substring after frag. If boolean is true
b ] where a is the substring within string before the first occurrence of frag in string
Adds a specified number of months to a period
Returns the difference between two periods
Returns the value of a number raised to the power of another number
Returns the quarter of the year for a given date value
Quotes the specified identifier. Identifier is surrounded by double quotes
Returns a new UUID with 122 pseudo random bits
Converts a string or bytes to the hex representation
Replaces each substring that matches a regular expression
Repeats a string as many times as specified
Replaces all occurrences of a substring within a string
Returns the string obtained by replacing any character in s1 that is also in s2 with the character s3
Reverses a string and returns the result
Extracts a number of characters from a string (starting from right)
Rounds a number to a specified number of decimal places
This function rounds numbers in a good way
b ] where a is the substring within string before the last occurrence of frag in string
Returns a time value based on the specified seconds
Returns the seconds part of a time/datetime
Generates a number of cryptographically secure random numbers
Returns a four character code representing the sound of a string
Returns a string of the specified number of space characters
Returns the array of strings obtained by splitting the string at wherever separator is found in it.
Returns an array of strings obtained by splitting s into groups of consecutive characters where the characters within each group share the same unicode type
Returns the array of strings obtained by splitting s into substrings with the given lengths.
Checks if s1 starts with s2 and returns a boolean
Returns a date based on a string and a format
Functions that measure distance between two strings
Converts a encoded string using the Java string literal encoding format
Encodes special characters in a string using the Java string literal encoding format
Encodes a string to a byte array using the UTF8 encoding format
Returns a substring of a string before a specified number of delimiter occurs
Subtracts a time interval from a datetime and then returns the time/datetime
Extracts the time part from a given time/datetime
Returns the difference between two time/datetime expressions
Returns a datetime value based on a date or datetime value
Oracle-compatible TO_CHAR function that can format a timestamp
Returns the value converted in date. Month_first false if date is formatted with the day before the month. FormatN formats of the input (don't understand this very well)
Returns the number of days between a date and date 0000-00-00''
Returns the string converted to titlecase (first letter of each word in uppercase)
Oracle-compatible TRANSLATE function that replaces a sequence of characters in a string with another set of characters
Removes leading and trailing spaces from a string
Truncates a number to the specified number of decimal places
Decodes a byte array in the UTF8 format to a string
Returns the week number for a given date
Returns the weekday number for a given date
Creates an XML attribute element of the form name=value
Returns the year and week number for a given date