sql:bit-length |
Returns the length of the string "str" in bits. |
sql:collated-string |
Returns an rdf:collatedString value with the given value and collation tag. |
sql:collatedString-collation |
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: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: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:octet-length |
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 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. |