Reference Guide > TDV Built-in Functions for XQuery > formatDateSequence
 
formatDateSequence
This function formats a sequence of dates as a comma-separated list of SQL literals.
Syntax
composite:formatDateSequence ($values as node()*)
Example
declare variable $values := <a><b>2012-06-01</b><b>2012-07-01</b></a>;
<result>{composite:formatDateSequence ($values//b)}</result>
Result
The output is of the form xs:string:
<result>'2012-06-01','2012-07-01'</result>