public interface SqlExpr
| Modifier and Type | Method and Description |
|---|---|
ServerExpression |
bitLength(ServerExpression str)
Returns the length of the string "str" in
bits.
|
ServerExpression |
bucket(ServerExpression bucketEdgesParam,
ServerExpression srchParam)
Returns an unsignedLong specifying the index of
the bucket the second parameter belongs to in buckets formed by the
first parameter.
|
ServerExpression |
bucket(ServerExpression bucketEdgesParam,
ServerExpression srchParam,
ServerExpression collationLiteral)
Returns an unsignedLong specifying the index of
the bucket the second parameter belongs to in buckets formed by the
first parameter.
|
ServerExpression |
bucket(ServerExpression bucketEdgesParam,
java.lang.String srchParam)
Returns an unsignedLong specifying the index of
the bucket the second parameter belongs to in buckets formed by the
first parameter.
|
ServerExpression |
bucket(ServerExpression bucketEdgesParam,
java.lang.String srchParam,
java.lang.String collationLiteral)
Returns an unsignedLong specifying the index of
the bucket the second parameter belongs to in buckets formed by the
first parameter.
|
ServerExpression |
collatedString(ServerExpression string,
ServerExpression collationURI)
Returns an rdf:collatedString value with the
given value and collation tag.
|
ServerExpression |
collatedString(ServerExpression string,
java.lang.String collationURI)
Returns an rdf:collatedString value with the
given value and collation tag.
|
ServerExpression |
dateadd(ServerExpression datepart,
int number, ServerExpression date)
Returns a specified date with the specified
number interval (signed integer) added to a specified datepart of
that date
|
ServerExpression |
dateadd(ServerExpression datepart,
ServerExpression number,
ServerExpression date)
|
ServerExpression |
datediff(ServerExpression datepart,
ServerExpression startdate,
ServerExpression enddate)
Returns the count (signed integer) of the
specified datepart boundaries crossed between the specified
startdate and enddate.
|
ServerExpression |
datepart(ServerExpression datepart,
ServerExpression date)
Returns an integer that represents the specified
datepart of the specified date.
|
ServerExpression |
day(ServerExpression arg)
Returns an xs:integer between 1 and 31, both
inclusive, representing the day component in the localized value of
arg.
|
ServerExpression |
dayname(ServerExpression arg)
Returns an xs:string representing the dayname
value in the localized value of arg.
|
ServerExpression |
glob(ServerExpression input,
ServerExpression pattern)
Returns true if the specified input glob the
specified pattern, otherwise returns false.
|
ServerExpression |
glob(ServerExpression input,
java.lang.String pattern)
Returns true if the specified input glob the
specified pattern, otherwise returns false.
|
ServerExpression |
hours(ServerExpression arg)
Returns an xs:integer between 0 and 23, both
inclusive, representing the value of the hours component in the
localized value of arg.
|
ServerExpression |
ifnull(ServerExpression expr1,
ServerExpression expr2)
If the first expression is NULL, then the value
of the second expression is returned.
|
ServerExpression |
insert(ServerExpression str,
double start, double length,
java.lang.String str2)
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.
|
ServerExpression |
insert(ServerExpression str,
ServerExpression start,
ServerExpression length,
ServerExpression str2)
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.
|
ServerExpression |
instr(ServerExpression str,
ServerExpression n)
Find the starting location of a pattern in a
string.
|
ServerExpression |
instr(ServerExpression str,
java.lang.String n)
Find the starting location of a pattern in a
string.
|
ServerExpression |
left(ServerExpression str,
double n)
Returns a string that is the leftmost characters
of the target string.
|
ServerExpression |
left(ServerExpression str,
ServerExpression n)
Returns a string that is the leftmost characters
of the target string.
|
ServerExpression |
like(ServerExpression input,
ServerExpression pattern)
Returns true if the specified input like the
specified pattern, otherwise returns false.
|
ServerExpression |
like(ServerExpression input,
ServerExpression pattern,
ServerExpression escape)
Returns true if the specified input like the
specified pattern, otherwise returns false.
|
ServerExpression |
like(ServerExpression input,
java.lang.String pattern)
Returns true if the specified input like the
specified pattern, otherwise returns false.
|
ServerExpression |
like(ServerExpression input,
java.lang.String pattern, java.lang.String escape)
Returns true if the specified input like the
specified pattern, otherwise returns false.
|
ServerExpression |
ltrim(ServerExpression str)
Return a string that removes leading empty
spaces in the input string.
|
ServerExpression |
minutes(ServerExpression arg)
Returns an xs:integer value between 0 to 59,
both inclusive, representing the value of the minutes component in
the localized value of arg.
|
ServerExpression |
month(ServerExpression arg)
Returns an xs:integer between 1 and 12, both
inclusive, representing the month component in the localized value
of arg.
|
ServerExpression |
monthname(ServerExpression arg)
Returns month name, calculated from the
localized value of arg.
|
ServerExpression |
nullif(ServerExpression expr1,
ServerExpression expr2)
Returns a NULL value if the two specified values
are equal.
|
ServerExpression |
octetLength(ServerExpression x)
Returns the length of the string "str" in
bits.
|
ServerExpression |
quarter(ServerExpression arg)
Returns an xs:integer between 1 and 4, both
inclusive, calculating the quarter component in the localized value
of arg.
|
ServerExpression |
rand(ServerExpression n)
Return a random number.
|
ServerExpression |
repeat(ServerExpression str,
double n)
Returns a string that concatenates the first
argument as many times as specified by the second argument.
|
ServerExpression |
repeat(ServerExpression str,
ServerExpression n)
Returns a string that concatenates the first
argument as many times as specified by the second argument.
|
ServerExpression |
right(ServerExpression str,
double n)
Returns a string that is the rightmost
characters of the target string.
|
ServerExpression |
right(ServerExpression str,
ServerExpression n)
Returns a string that is the rightmost
characters of the target string.
|
ServerExpression |
rowID(ServerExpression arg1)
Constructs a row identifier from the string form
of the temporary identifier assigned to a row during
processing.
|
ServerExpression |
rtrim(ServerExpression str)
Return a string that removes trailing empty
spaces in the input string.
|
ServerExpression |
seconds(ServerExpression arg)
Returns an xs:decimal value between 0 and
60.999..., both inclusive, representing the seconds and fractional
seconds in the localized value of arg.
|
ServerExpression |
sign(ServerExpression x)
Returns the sign of number x.
|
ServerExpression |
soundex(ServerExpression arg)
Returns a four-character (SOUNDEX) code to
evaluate the similarity of two strings.
|
ServerExpression |
space(ServerExpression n)
Returns a string that is the given number of
spaces.
|
ServerExpression |
strpos(ServerExpression target,
ServerExpression test)
Returns an integer value representing the
starting position of a string within the search string.
|
ServerExpression |
strpos(ServerExpression target,
ServerExpression test,
ServerExpression collation)
Returns an integer value representing the
starting position of a string within the search string.
|
ServerExpression |
strpos(ServerExpression target,
java.lang.String test)
Returns an integer value representing the
starting position of a string within the search string.
|
ServerExpression |
strpos(ServerExpression target,
java.lang.String test, java.lang.String collation)
Returns an integer value representing the
starting position of a string within the search string.
|
ServerExpression |
timestampadd(ServerExpression dateTimeType,
int value, ServerExpression timestamp)
Returns a xs:string? timestamp created by adding
a number to the given dateTimeType field of a given
timestamp.
|
ServerExpression |
timestampadd(ServerExpression dateTimeType,
ServerExpression value,
ServerExpression timestamp)
Returns a xs:string? timestamp created by adding
a number to the given dateTimeType field of a given
timestamp.
|
ServerExpression |
timestampdiff(ServerExpression dateTimeType,
ServerExpression timestamp1,
ServerExpression timestamp2)
Returns the difference in dateTimeType field of
two given timestamps.
|
ServerExpression |
trim(ServerExpression str)
Return a string that removes leading and
trailing empty spaces in the input string.
|
ServerExpression |
week(ServerExpression arg)
Returns an xs:integer between 1 and 53, both
inclusive, representing the week value in the localized value of
arg.
|
ServerExpression |
weekday(ServerExpression arg1)
Returns the day of the week.
|
ServerExpression |
year(ServerExpression arg)
Returns an xs:integer representing the year
component in the localized value of arg.
|
ServerExpression |
yearday(ServerExpression arg)
Returns an xs:integer between 1 and 366, both
inclusive, representing the yearday value in the localized value of
arg.
|
ServerExpression bitLength(ServerExpression str)
Provides a client interface to the sql:bit-length server function.
str - The string to be evaluated. (of xs:string)ServerExpression bucket(ServerExpression bucketEdgesParam, java.lang.String srchParam)
Provides a client interface to the sql:bucket server function.
bucketEdgesParam - A sequence of ordered values
indicating the edges of a collection of buckets. If the sequence is
out of order or has duplicates, SQL-UNORDERED is thrown. (of
xs:anyAtomicType)srchParam - A value to find an index for in the
bucket edge list. (of xs:anyAtomicType)ServerExpression bucket(ServerExpression bucketEdgesParam, ServerExpression srchParam)
Provides a client interface to the sql:bucket server function.
bucketEdgesParam - A sequence of ordered values
indicating the edges of a collection of buckets. If the sequence is
out of order or has duplicates, SQL-UNORDERED is thrown. (of
xs:anyAtomicType)srchParam - A value to find an index for in the
bucket edge list. (of xs:anyAtomicType)ServerExpression bucket(ServerExpression bucketEdgesParam, java.lang.String srchParam, java.lang.String collationLiteral)
Provides a client interface to the sql:bucket server function.
bucketEdgesParam - A sequence of ordered values
indicating the edges of a collection of buckets. If the sequence is
out of order or has duplicates, SQL-UNORDERED is thrown. (of
xs:anyAtomicType)srchParam - A value to find an index for in the
bucket edge list. (of xs:anyAtomicType)collationLiteral - A collation identifier. All
bucketEdgesParam and srcParam are converted to a string of this
collation if supplied. (of xs:string)ServerExpression bucket(ServerExpression bucketEdgesParam, ServerExpression srchParam, ServerExpression collationLiteral)
Provides a client interface to the sql:bucket server function.
bucketEdgesParam - A sequence of ordered values
indicating the edges of a collection of buckets. If the sequence is
out of order or has duplicates, SQL-UNORDERED is thrown. (of
xs:anyAtomicType)srchParam - A value to find an index for in the
bucket edge list. (of xs:anyAtomicType)collationLiteral - A collation identifier. All
bucketEdgesParam and srcParam are converted to a string of this
collation if supplied. (of xs:string)ServerExpression collatedString(ServerExpression string, java.lang.String collationURI)
Provides a client interface to the sql:collated-string server function.
ServerExpression collatedString(ServerExpression string, ServerExpression collationURI)
Provides a client interface to the sql:collated-string server function.
ServerExpression dateadd(ServerExpression datepart, int number, ServerExpression date)
Provides a client interface to the sql:dateadd server function.
datepart - Is the part of date where the number
will be added. The following table lists all valid datepart
arguments. User-defined variable equivalents are not valid. The
return data type is the data type of the date argument. Options:
datepart parameter abbreviation includes: "year","yyyy","yy" The
year part of the date "quarter","qq","q" The quarter part of the
date "month","mm","m" The month part of the date
"dayofyear","dy","y" The day of the year from the date
"day","dd","d" The day of the month from the date "week","wk","ww"
The week of the year from the date "weekday","dw" The day of the
week from the date "hour","hh" The hour of the day from the date
"minute","mi","n" The minute of the hour from the date
"second","ss","s" The second of the minute from the date
"millisecond","ms" The millisecond of the minute from the date
"microsecond","msc" The microsecond of the minute from the date
"nanosecond","ns" The nanosecond of the minute from the date (of
xs:string)number - This number will be added to the datepart
of the given date. (of xs:int)date - Is an expression that can be resolved to a
time, date or datetime, value. date can be an expression, column
expression, user-defined variable or string literal. startdate is
subtracted from enddate. (of item)ServerExpression dateadd(ServerExpression datepart, ServerExpression number, ServerExpression date)
Provides a client interface to the sql:dateadd server function.
datepart - Is the part of date where the number
will be added. The following table lists all valid datepart
arguments. User-defined variable equivalents are not valid. The
return data type is the data type of the date argument. Options:
datepart parameter abbreviation includes: "year","yyyy","yy" The
year part of the date "quarter","qq","q" The quarter part of the
date "month","mm","m" The month part of the date
"dayofyear","dy","y" The day of the year from the date
"day","dd","d" The day of the month from the date "week","wk","ww"
The week of the year from the date "weekday","dw" The day of the
week from the date "hour","hh" The hour of the day from the date
"minute","mi","n" The minute of the hour from the date
"second","ss","s" The second of the minute from the date
"millisecond","ms" The millisecond of the minute from the date
"microsecond","msc" The microsecond of the minute from the date
"nanosecond","ns" The nanosecond of the minute from the date (of
xs:string)number - This number will be added to the datepart
of the given date. (of xs:int)date - Is an expression that can be resolved to a
time, date or datetime, value. date can be an expression, column
expression, user-defined variable or string literal. startdate is
subtracted from enddate. (of item)ServerExpression datediff(ServerExpression datepart, ServerExpression startdate, ServerExpression enddate)
Provides a client interface to the sql:datediff server function.
datepart - Is the part of startdate and enddate
that specifies the type of boundary crossed. The following table
lists all valid datepart arguments. User-defined variable
equivalents are not valid. Options: datepart parameter abbreviation
includes: "year","yyyy","yy" The year part of the date
"quarter","qq","q" The quarter part of the date "month","mm","m"
The month part of the date "dayofyear","dy","y" The day of the year
from the date "day","dd","d" The day of the month from the date
"week","wk","ww" The week of the year from the date "weekday","dw"
The day of the week from the date "hour","hh" The hour of the day
from the date "minute","mi","n" The minute of the hour from the
date "second","ss","s" The second of the minute from the date
"millisecond","ms" The millisecond of the minute from the date
"microsecond","msc" The microsecond of the minute from the date
"nanosecond","ns" The nanosecond of the minute from the date (of
xs:string)startdate - Is an expression that can be resolved
to a time, date, datetime or value. date can be an expression,
column expression, user-defined variable or string literal.
startdate is subtracted from enddate. (of item)enddate - Same as startdate. (of item)ServerExpression datepart(ServerExpression datepart, ServerExpression date)
Provides a client interface to the sql:datepart server function.
datepart - The part of date that to be returned.
Options: datepart parameter abbreviation includes:
"year","yyyy","yy" The year part of the date "quarter","qq","q" The
quarter part of the date "month","mm","m" The month part of the
date "dayofyear","dy","y" The day of the year from the date
"day","dd","d" The day of the month from the date "week","wk","ww"
The week of the year from the date "weekday","dw" The day of the
week from the date "hour","hh" The hour of the day from the date
"minute","mi","n" The minute of the hour from the date
"second","ss","s" The second of the minute from the date
"millisecond","ms" The millisecond of the minute from the date
"microsecond","msc" The microsecond of the minute from the date
"nanosecond","ns" The nanosecond of the minute from the date
"TZoffset","tz" The timezone offset from the date (of xs:string)date - Is an expression that can be resolved to a
xs:date, xs:time, xs:dateTime. date can be an expression, column
expression,user-defined variable, or string literal. (of item)ServerExpression day(ServerExpression arg)
Provides a client interface to the sql:day server function.
arg - The xs:genericDateTimeArg whose day
component will be returned. (of item)ServerExpression dayname(ServerExpression arg)
Provides a client interface to the sql:dayname server function.
ServerExpression glob(ServerExpression input, java.lang.String pattern)
Provides a client interface to the sql:glob server function.
input - The input from which to match. (of
xs:string)pattern - The expression to match. '?' matches one
character and '*' matches any number of characters. (of xs:string)ServerExpression glob(ServerExpression input, ServerExpression pattern)
Provides a client interface to the sql:glob server function.
input - The input from which to match. (of
xs:string)pattern - The expression to match. '?' matches one
character and '*' matches any number of characters. (of xs:string)ServerExpression hours(ServerExpression arg)
Provides a client interface to the sql:hours server function.
arg - The genericDateTime whose hours component
will be returned. (of item)ServerExpression ifnull(ServerExpression expr1, ServerExpression expr2)
Provides a client interface to the sql:ifnull server function.
expr1 - First expression to be evaluated. (of
item)expr2 - Second expression to be evaluated. (of
item)ServerExpression insert(ServerExpression str, double start, double length, java.lang.String str2)
Provides a client interface to the sql:insert server function.
str - The string to manipulate. (of xs:string)start - The starting position where characters
will be inserted. (of xs:numeric)length - The number of characters to be removed.
(of xs:numeric)str2 - The string to insert. (of xs:string)ServerExpression insert(ServerExpression str, ServerExpression start, ServerExpression length, ServerExpression str2)
Provides a client interface to the sql:insert server function.
str - The string to manipulate. (of xs:string)start - The starting position where characters
will be inserted. (of xs:numeric)length - The number of characters to be removed.
(of xs:numeric)str2 - The string to insert. (of xs:string)ServerExpression instr(ServerExpression str, java.lang.String n)
Provides a client interface to the sql:instr server function.
str - The string to be evaluated. (of xs:string)n - The pattern to be evaluated. (of xs:string)ServerExpression instr(ServerExpression str, ServerExpression n)
Provides a client interface to the sql:instr server function.
str - The string to be evaluated. (of xs:string)n - The pattern to be evaluated. (of xs:string)ServerExpression left(ServerExpression str, double n)
Provides a client interface to the sql:left server function.
str - The base string. If the value is not a
string, its string value will be used. (of xs:anyAtomicType)n - The number of leftmost characters of the
string to return. (of xs:numeric)ServerExpression left(ServerExpression str, ServerExpression n)
Provides a client interface to the sql:left server function.
str - The base string. If the value is not a
string, its string value will be used. (of xs:anyAtomicType)n - The number of leftmost characters of the
string to return. (of xs:numeric)ServerExpression like(ServerExpression input, java.lang.String pattern)
Provides a client interface to the sql:like server function.
input - The input from which to match. (of
xs:string)pattern - The expression to match. '_' matches one
character and '%' matches any number of characters. (of xs:string)ServerExpression like(ServerExpression input, ServerExpression pattern)
Provides a client interface to the sql:like server function.
input - The input from which to match. (of
xs:string)pattern - The expression to match. '_' matches one
character and '%' matches any number of characters. (of xs:string)ServerExpression like(ServerExpression input, java.lang.String pattern, java.lang.String escape)
Provides a client interface to the sql:like server function.
input - The input from which to match. (of
xs:string)pattern - The expression to match. '_' matches one
character and '%' matches any number of characters. (of xs:string)escape - If a '_' or '%' are preceeded by an
escape character then it will be match as the char '_'/'%'
themselves. (of xs:string)ServerExpression like(ServerExpression input, ServerExpression pattern, ServerExpression escape)
Provides a client interface to the sql:like server function.
input - The input from which to match. (of
xs:string)pattern - The expression to match. '_' matches one
character and '%' matches any number of characters. (of xs:string)escape - If a '_' or '%' are preceeded by an
escape character then it will be match as the char '_'/'%'
themselves. (of xs:string)ServerExpression ltrim(ServerExpression str)
Provides a client interface to the sql:ltrim server function.
ServerExpression minutes(ServerExpression arg)
Provides a client interface to the sql:minutes server function.
arg - The genericDateTime whose minutes component
will be returned. (of item)ServerExpression month(ServerExpression arg)
Provides a client interface to the sql:month server function.
arg - The genericDateTime whose month component
will be returned. (of item)ServerExpression monthname(ServerExpression arg)
Provides a client interface to the sql:monthname server function.
ServerExpression nullif(ServerExpression expr1, ServerExpression expr2)
Provides a client interface to the sql:nullif server function.
expr1 - First expression to be evaluated. (of
item)expr2 - Second expression to be evaluated. (of
item)ServerExpression octetLength(ServerExpression x)
Provides a client interface to the sql:octet-length server function.
x - The string to be evaluated. (of xs:string)ServerExpression quarter(ServerExpression arg)
Provides a client interface to the sql:quarter server function.
arg - The genericDateTime whose quarter component
will be returned. (of item)ServerExpression rand(ServerExpression n)
Provides a client interface to the sql:rand server function.
n - The random seed. Currently this parameter is
ignored. (of xs:unsignedLong)ServerExpression repeat(ServerExpression str, double n)
Provides a client interface to the sql:repeat server function.
str - The string to duplicate. If the value is not
a string, its string value will be used. (of item)n - The number of times to repeat the string. (of
xs:numeric)ServerExpression repeat(ServerExpression str, ServerExpression n)
Provides a client interface to the sql:repeat server function.
str - The string to duplicate. If the value is not
a string, its string value will be used. (of item)n - The number of times to repeat the string. (of
xs:numeric)ServerExpression right(ServerExpression str, double n)
Provides a client interface to the sql:right server function.
str - The base string. If the value is not a
string, its string value will be used. (of xs:anyAtomicType)n - The number of rightmost characters of the
string to return. (of xs:numeric)ServerExpression right(ServerExpression str, ServerExpression n)
Provides a client interface to the sql:right server function.
str - The base string. If the value is not a
string, its string value will be used. (of xs:anyAtomicType)n - The number of rightmost characters of the
string to return. (of xs:numeric)ServerExpression rowID(ServerExpression arg1)
arg1 - the arg1 value. (of xs:anyAtomicType)ServerExpression rtrim(ServerExpression str)
Provides a client interface to the sql:rtrim server function.
ServerExpression seconds(ServerExpression arg)
Provides a client interface to the sql:seconds server function.
arg - The time whose seconds component will be
returned. (of item)ServerExpression sign(ServerExpression x)
Provides a client interface to the sql:sign server function.
x - The number to be evaluated. (of xs:numeric)ServerExpression soundex(ServerExpression arg)
Provides a client interface to the sql:soundex server function.
ServerExpression space(ServerExpression n)
Provides a client interface to the sql:space server function.
n - The number of spaces to return as a string.
(of xs:numeric)ServerExpression strpos(ServerExpression target, java.lang.String test)
Provides a client interface to the sql:strpos server function.
target - The string from which to test. (of
xs:string)test - The string to test for existence in the
second parameter. (of xs:string)ServerExpression strpos(ServerExpression target, ServerExpression test)
Provides a client interface to the sql:strpos server function.
target - The string from which to test. (of
xs:string)test - The string to test for existence in the
second parameter. (of xs:string)ServerExpression strpos(ServerExpression target, java.lang.String test, java.lang.String collation)
Provides a client interface to the sql:strpos server function.
target - The string from which to test. (of
xs:string)test - The string to test for existence in the
second parameter. (of xs:string)collation - The optional name of a valid collation
URI. For information on the collation URI syntax, see the Search
Developer's Guide. (of xs:string)ServerExpression strpos(ServerExpression target, ServerExpression test, ServerExpression collation)
Provides a client interface to the sql:strpos server function.
target - The string from which to test. (of
xs:string)test - The string to test for existence in the
second parameter. (of xs:string)collation - The optional name of a valid collation
URI. For information on the collation URI syntax, see the Search
Developer's Guide. (of xs:string)ServerExpression timestampadd(ServerExpression dateTimeType, int value, ServerExpression timestamp)
Provides a client interface to the sql:timestampadd server function.
dateTimeType - The dateTimeType of the timestamp
where addition should take place. Available types are:
SQL_TSI_FRAC_SECOND nano seconds SQL_TSI_SECOND seconds
SQL_TSI_MINUTE minute SQL_TSI_HOUR hour SQL_TSI_DAY day
SQL_TSI_WEEK week SQL_TSI_MONTH month SQL_TSI_QUARTER quarter
SQL_TSI_YEAR year (of xs:string)value - The integer to add to the given
dateTimeType field of the third parameter. (of xs:int)timestamp - The xs:dateTime timestamp to which
addition has to take place. (of item)ServerExpression timestampadd(ServerExpression dateTimeType, ServerExpression value, ServerExpression timestamp)
Provides a client interface to the sql:timestampadd server function.
dateTimeType - The dateTimeType of the timestamp
where addition should take place. Available types are:
SQL_TSI_FRAC_SECOND nano seconds SQL_TSI_SECOND seconds
SQL_TSI_MINUTE minute SQL_TSI_HOUR hour SQL_TSI_DAY day
SQL_TSI_WEEK week SQL_TSI_MONTH month SQL_TSI_QUARTER quarter
SQL_TSI_YEAR year (of xs:string)value - The integer to add to the given
dateTimeType field of the third parameter. (of xs:int)timestamp - The xs:dateTime timestamp to which
addition has to take place. (of item)ServerExpression timestampdiff(ServerExpression dateTimeType, ServerExpression timestamp1, ServerExpression timestamp2)
Provides a client interface to the sql:timestampdiff server function.
dateTimeType - The dateTimeType of the timestamp
where addition should take place. Available types are:
SQL_TSI_FRAC_SECOND nano seconds SQL_TSI_SECOND seconds
SQL_TSI_MINUTE minute SQL_TSI_HOUR hour SQL_TSI_DAY day
SQL_TSI_WEEK week SQL_TSI_MONTH month SQL_TSI_QUARTER quarter
SQL_TSI_YEAR year (of xs:string)timestamp1 - The integer to add to the given
dateTimeType field of the third parameter. (of item)timestamp2 - The xs:dateTime timestamp to which
addition has to take place. (of item)ServerExpression trim(ServerExpression str)
Provides a client interface to the sql:trim server function.
ServerExpression week(ServerExpression arg)
Provides a client interface to the sql:week server function.
arg - The dateTime/date/string whose day component
will be returned. (of item)ServerExpression weekday(ServerExpression arg1)
arg1 - the arg1 value. (of item)ServerExpression year(ServerExpression arg)
Provides a client interface to the sql:year server function.
arg - The dateTime/date/string whose day component
will be returned. (of item)ServerExpression yearday(ServerExpression arg)
Provides a client interface to the sql:yearday server function.
arg - The xs:genericDateTimeArg whose days of the
year will be returned. (of item)Copyright © 2024 MarkLogic Corporation. All Rights Reserved.