sql functions

The table below lists all the sql built-in functions (in this namespace: http://marklogic.com/xdmp/sql).

You can also view these functions broken down by category:

37 functions
Function name Description
sql.bitLength Returns the length of the string "str" in bits.
sql.bucket Returns an unsignedLong specifying the index of the bucket the second parameter belongs to in buckets formed by the first parameter.
sql.collatedString Returns an rdf.collatedString value with the given value and collation tag.
sql.collatedStringCollation Returns the collation of an sql.collatedString value.
sql.columnID Returns the column ID from a schema name, a view name and a column name.
sql.day Returns an xs:integer between 1 and 31, both inclusive, representing the day component in the localized value of $arg.
sql.dayname Returns an xs:string representing the dayname value in the localized value of $arg.
sql.difference Returns an integer value that indicates the difference between the SOUNDEX values of two character expressions.
sql.glob Returns true if the specified $input glob the specified $pattern, otherwise returns false.
sql.hours Returns an xs:integer between 0 and 23, both inclusive, representing the value of the hours component in the localized value of $arg.
sql.ifnull If the first expression is NULL, then the value of the second expression is returned.
sql.insert Returns a string that that is the first argument with length characters removed starting at start and the second string has been inserted beginning at start.
sql.instr Find the starting location of a pattern in a string.
sql.left Returns a string that is the leftmost characters of the target string.
sql.like Returns true if the specified $input like the specified $pattern, otherwise returns false.
sql.ltrim Return a string that removes leading empty spaces in the input string.
sql.minutes Returns an xs:integer value between 0 to 59, both inclusive, representing the value of the minutes component in the localized value of $arg.
sql.month Returns an xs:integer between 1 and 12, both inclusive, representing the month component in the localized value of $arg.
sql.monthname Returns month name, calculated from the localized value of $arg.
sql.nullif Returns a NULL value if the two specified values are equal.
sql.octetLength Returns the length of the string "str" in bits.
sql.quarter Returns an xs:integer between 1 and 4, both inclusive, calculating the quarter component in the localized value of $arg.
sql.rand Return a random number.
sql.repeat Returns a string that concatenates the first argument as many times as specified by the second argument.
sql.right Returns a string that is the rightmost characters of the target string.
sql.rtrim Return a string that removes trailing empty spaces in the input string.
sql.seconds Returns an xs:decimal value between 0 and 60.999..., both inclusive, representing the seconds and fractional seconds in the localized value of $arg.
sql.sign Returns the sign of number x.
sql.soundex Returns a four-character (SOUNDEX) code to evaluate the similarity of two strings.
sql.space Returns a string that is the given number of spaces.
sql.strpos Returns an integer value representing the starting position of a string within the search string.
sql.timestampadd Returns a xs:string? timestamp created by adding a number to the given dateTimeType field of a given timestamp.
sql.timestampdiff Returns the difference in dateTimeType field of two given timestamps.
sql.trim Return a string that removes leading and trailing empty spaces in the input string.
sql.week Returns an xs:integer between 1 and 53, both inclusive, representing the week value in the localized value of $arg.
sql.year Returns an xs:integer representing the year component in the localized value of $arg.
sql.yearday Returns an xs:integer between 1 and 366, both inclusive, representing the yearday value in the localized value of $arg.
Powered by MarkLogic Server | Terms of Use | Privacy Policy