XQuery Reference

Previous

Next

Contents

XQuery Reference

Topics Included in This Section

XQuery Alphabetical Functions and Operators Reference

XQuery String Functions Reference

xf:concat

bea-xf: trim-left

XQuery Compliance

Remove Leading Spaces

bea-xf: trim-right

Remove Trailing Spaces

XQuery Compliance

bea-xf: trim

Remove Leading and Trailing Spaces

XQuery Compliance

xs: normalizedString

Remove Carriage Returns

xs: token

Remove Carriage Returns

Collapse Spaces

xf: compare

Greater Than (+1)

xf: starts-with

xf: ends-with

xf: contains

xf: substring

substring($string-var, $decimal-var)

substring($string-var, $decimal-var, $optional-decimal-var)

Specify Just the Starting Position

Specify the Starting Position and Length

From the Middle of the String

Error—Out of Bounds

xf: string-length

xf: substring-before

xf: substring-after

xf: normalize-space

Collapse Spaces

xf: upper-case

xf: lower-case

xf: translate

Replacement String Longer Than Source String

Replacement String Is Empty

Search String Is Empty

xf: string-pad

xf: matches

Regular Expression Matches

Regular Expression Does Not Match

Beginning Anchor Matches

Beginning Anchor Does Not Match

Ending Anchor Matches

Ending Anchor Does Not Match

Case-Insensitive Mode

xf: replace

Greedy Qualifiers

Reluctant Qualifiers

Replacement String Is Empty

Case-Insensitive Mode

xf: tokenize

White Space Delimited List

Comma Delimited List

Comma and White Space Delimited List

Case-Insensitive Mode

XQuery Type Conversion Functions Reference

xs: string

xs: decimal

xs: integer

Error—Decimal Point is Not Allowed

Error—Not a Number

XQuery Compliance

xs: long

Error—Decimal Point Not Allowed

Error—Not a Number

xs: int

Error—Decimal Point Not Allowed

Error—Not a Number

xs: short

Error—Decimal Point Not Allowed

Error—Not a Number

xs: byte

Error—Decimal Point Not Allowed

Error—Not a Number

xs: float

Error—Invalid Exponent

xs: double

Error—Invalid Exponent

xf: number

bea-xf: integer-sequence

xs: boolean

xs: dateTime

Seconds with Decimal

Offset Time Zone

Error—No Seconds

Error—Incorrect Format

xs: date

Offset Time Zone

Error—Not A Valid Date

Error—Incorrect Format

xs:time

Error—Incorrect Format

xs: gYearMonth

Error—Incorrect Format

xs: gYear

xs: gMonthDay

Error—Incorrect Format

xs: gMonth

Error—Incorrect Format

xs: gDay

Error—Incorrect Format

xs: duration

duration with Just Years

duration with Just Negative Months

duration with Just Days and Seconds

xs: anyURI

xs: Name

xs: QName

XQuery URI Functions Reference

xf: escape-URI

xf: resolve-URI

Resolve-URI Example 1

Resolve-URI Example 2

Resolve-URI Example 3

XQuery Numeric Function Reference

bea-xf: format-number

Add Comma And More Decimal Places

XQuery Compliance

xf: floor

xf: ceiling

xf: round

XQuery Aggregate Function Reference

xf: count

xf: avg

Empty Sequences

xf: max

Empty Sequences

xf: min

Empty Sequences

xf: sum

Empty Sequences

XQuery Node Functions Reference

xf: node-kind

xf: node-name

xf: local-name

XQuery Date Functions Reference

xf: get-year-from-dateTime

xf: get-month-from-dateTime

xf: get-day-from-dateTime

xf: get-hours-from-dateTime

xf: get-minutes-from-dateTime

xf: get-seconds-from-dateTime

xf: get-timezone-from-dateTime

xf: get-year-from-date

xf: get-month-from-date

xf: get-day-from-date

xf: get-timezone-from-date

xf: get-hours-from-time

xf: get-minutes-from-time

xf: get-seconds-from-time

xf: get-timezone-from-time

xf: add-timezone-to-dateTime

Adding the Specified Timezone to the dateTime Value

Adding the Implicit Timezone to the dateTime Value

xf: remove-timezone-from-dateTime

Removing the Specified Timezone From a dateTime Value

Removing the Implicit Timezone From the dateTime Value

xf: add-timezone-to-date

Adding the Specified Timezone to the date Value

Adding the Implicit Timezone to the date Value

xf: add-timezone-to-time

Adding the Specified Timezone to the time Value

Adding the Implicit Timezone to the time Value

xf: remove-timezone-from-time

Removing the Specified Timezone From a time Value

Removing the Implicit Timezone From the time Value

xf: current-dateTime

Invoke Multiple Times

xf: current-date

xf: current-time

Invoke Multiple Times

XQuery QName Functions Reference

xf: get-local-name-from-QName

xf: get-namespace-from-QName

XQuery Boolean Operators Reference

op: boolean-equal

Not Equal Returns false

Equal Returns true

op: boolean-less-than

boolean-less-than(false, true) Returns true

boolean-less-than(true, false) Returns false

op: boolean-greater-than

boolean-greater-than(true, false) Returns true

boolean-greater-than(false, true) Returns false

XQuery Duration Functions Reference

xf: yearMonthDuration

yearMonthDuration with Year and Month

yearMonthDuration with Year

yearMonthDuration with Negative Month

xf: dayTimeDuration

dayTimeDuration with All Components

dayTimeDuration with Just Hours and Seconds

dayTimeDuration with Just Negative Days

xf: get-years-from-yearMonthDuration

Get Years from yearMonthDuration with Years and Months

Get Years from yearMonthDuration with Just Negative Years

Get Years from yearMonthDuration with Just Months

xf: get-months-from-yearMonthDuration

Get Months from yearMonthDuration with Years and Months

Get Months from yearMonthDuration with Just Negative Months

xf: get-days-from-dayTimeDuration

Get Days from dayTimeDuration with All Components

Get Days from dayTimeDuration with Just Negative Days

Get Days from dayTimeDuration with No Days

xf: get-hours-from-dayTimeDuration

Get Hours from dayTimeDuration with All Components

Get Hours from dayTimeDuration with Just Negative Hours

Get Hours from dayTimeDuration with No Hours

xf: get-minutes-from-dayTimeDuration

Get Minutes from dayTimeDuration with All Components

Get Minutes from dayTimeDuration with Just Negative Minutes

Get Minutes from dayTimeDuration with No Minutes

xf: get-seconds-from-dayTimeDuration

Get Seconds from dayTimeDuration with All Components

Get Seconds from dayTimeDuration with Just Negative Seconds

Get Seconds from dayTimeDuration with No Seconds

xf: get-yearMonthDuration-from-dateTimes

Positive Difference

Negative Difference

Not Enough to Round Up

xf: get-dayTimeDuration-from-dateTimes

Positive Difference

Negative Difference

XQuery Numeric Operators Reference

op: decimal-add

op: decimal-subtract

op: float-subtract

op: double-subtract

op: decimal-multiply

op: float-multiply

op: double-multiply

op: decimal-divide

Error—Divide by Zero

op: float-divide

op: double-divide

op: numeric-integer-divide

Throw Away Remainder

Error—Divide by Zero

op: decimal-mod

Error—Divide by Zero

XQuery Date and Time Operators Reference

op: subtract-dates

Positive Difference

Negative Difference

op: subtract-times

op: add-yearMonthDuration-to-dateTime

op: add-dayTimeDuration-to-dateTime

op: subtract-yearMonthDuration-from-dateTime

Subtracting a Positive yearMonthDuration

Subtracting a Negative yearMonthDuration

op: subtract-dayTimeDuration-from-dateTime

Subtracting a Positive dayTimeDuration

Subtracting a Negative dayTimeDuration

op: add-yearMonthDuration-to-date

op: add-dayTimeDuration-to-date

op: subtract-yearMonthDuration-from-date

Subtracting a Positive yearMonthDuration

Subtracting a Negative yearMonthDuration

op: subtract-dayTimeDuration-from-date

Subtracting a Positive dayTimeDuration

Subtracting a Negative dayTimeDuration

op: add-dayTimeDuration-to-time

op: subtract-dayTimeDuration-from-time

Subtracting a Positive dayTimeDuration

Subtracting a Negative dayTimeDuration

XQuery Duration Operators Reference

op: add-yearMonthDurations

op: subtract-yearMonthDurations

op: multiply-yearMonthDuration

Not Enough to Round Up

op: divide-yearMonthDuration

Not Enough to Round Up

op: add-dayTimeDurations

op: subtract-dayTimeDurations

op: multiply-dayTimeDuration

op: divide-dayTimeDuration

XQuery Occurrence Indicators

None

?

*

+

XQuery Namespace Conventions

xs:

xf:

op:

bea-xf:

XQuery Data Types

item

integer

node

XQuery Language and XML Reference

XQuery Prologs

XQuery Expressions

XQuery FLWR Expressions

XQuery Namespaces

XQuery Function Definitions

XQuery Function Calls and Arguments

XQuery Path Expressions

XQuery Literals

XQuery Combining Sequences

XQuery Conditional Expressions

XQuery Logical Expressions

XQuery Comparison Expressions

XML Element Declarations

XML Attribute Declarations

XML CDATA Sections

XML Comments

XML Prolog and Document Type Declaration

ISO-3166 Country Codes and ISO-639 Language Codes

ISO-3166 Country Codes

Previous

Next