bucketbucketbucketbucketcollatedStringcollatedStringdateadddateadddatediffdatepartdaydaynameglobglobhoursifnullinsertinsertinstrinstrleftleftlikelikelikelikeltrimminutesmonthnullifquarterrepeatrepeatrightrightrowIDrtrimsecondssoundexstrposstrposstrposstrpostimestampaddtimestampaddtimestampdifftrimweekweekdayyearyeardayProvides a client interface to the sql:bit-length server function.
str - The string to be evaluated. (of xs:string)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)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)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)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)Provides a client interface to the sql:collated-string server function.
Provides a client interface to the sql:collated-string server function.
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)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)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)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)Provides a client interface to the sql:day server function.
arg - The xs:genericDateTimeArg whose day
component will be returned. (of item)Provides a client interface to the sql:dayname server function.
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)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)Provides a client interface to the sql:hours server function.
arg - The genericDateTime whose hours component
will be returned. (of item)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)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)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)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)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)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)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)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)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)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)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)Provides a client interface to the sql:ltrim server function.
Provides a client interface to the sql:minutes server function.
arg - The genericDateTime whose minutes component
will be returned. (of item)Provides a client interface to the sql:month server function.
arg - The genericDateTime whose month component
will be returned. (of item)Provides a client interface to the sql:monthname server function.
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)Provides a client interface to the sql:octet-length server function.
x - The string to be evaluated. (of xs:string)Provides a client interface to the sql:quarter server function.
arg - The genericDateTime whose quarter component
will be returned. (of item)Provides a client interface to the sql:rand server function.
n - The random seed. Currently this parameter is
ignored. (of xs:unsignedLong)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)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)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)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)arg1 - the arg1 value. (of xs:anyAtomicType)Provides a client interface to the sql:rtrim server function.
Provides a client interface to the sql:seconds server function.
arg - The time whose seconds component will be
returned. (of item)Provides a client interface to the sql:sign server function.
x - The number to be evaluated. (of xs:numeric)Provides a client interface to the sql:soundex server function.
Provides a client interface to the sql:space server function.
n - The number of spaces to return as a string.
(of xs:numeric)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)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)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)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)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)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)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)Provides a client interface to the sql:trim server function.
Provides a client interface to the sql:week server function.
arg - The dateTime/date/string whose day component
will be returned. (of item)arg1 - the arg1 value. (of item)Provides a client interface to the sql:year server function.
arg - The dateTime/date/string whose day component
will be returned. (of item)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 (c) 2010-2025 Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.