The replace function replaces the matched input string with a given string. Syntax replace($input, $regex, $string) Input Parameters $input − input string.$regex − regular expression.$string - string to replace original string. Example XQuery Expression let…
The matches function returns true if the input matches with the provided regular expression; otherwise false. Syntax matches($input, $regex) Input Parameters $input − input string.$regex − regular expression. Example XQuery Expression let $input :=…
The following table lists the commonly used date functions provided by XQuery. Sr.NoName & Description1current-date Function Returns the current date.2current-time Function Returns the current time.3current-dateTime Function Returns both the current…
The current-dateTime function is used to return the current date and time. Syntax current-dateTime() Example XQuery Expression let $datetime := current-dateTime() return <results> <datetime>{$datetime}</datetime> </results> Output <results> <datetime>2014-10-27T14:55:58.621+05:30</datetime>result </results> Here T separates…
The current-time function is used to return the current time. Syntax current-time() Example XQuery Expression let $time := current-time() return <results> <time>{$time}</time> </results> Output <results> <time>14:53:46.803+05:30</time> </results> Verify the Result In order…
The current-date function is used to return the current date. Syntax current-date() Example XQuery Expression let $date := current-date() return <results> <date>{$date}</date> </results> Output <results> <date>2014-10-27+05:30</date> </results> Here +5:30 is the relative…
The following table lists the commonly used string manipulation functions provided by XQuery. Sr.NoName & Description1string-length Function Returns the length of the string.2string-concat Function Returns the concatenated string as output.3string-join…
The string-join function is used to concatenate various sequences separated by a given delimiter. Syntax string-join($sequence as xs:string*, $delimiter as xs:string) as xs:string Input Parameters $sequence − sequence of zero or more strings.$delimiter −…
The concat function is used to concatenate various strings. Syntax concat($input as xs:anyAtomicType?) as xs:string Input Parameters $input − one or more inputs separated by comma. Example XQuery Expression let $bookTitle := "Learn…
The string-length function is used to get the length of a string. Syntax string-length($string as xs:string) as xs:integer Input Parameters $string − provided string. Example XQuery Expression let $bookTitle := "Learn XQuery in…