XML Data | XQL query returns (result returned as a String List) | Results stored as DATETIMELIST | Results stored as DATETIME |
<node></node> | null | null | null |
<node> <item></item> </node> | {""} (String List with one element, an empty String) | {null} (Datetime List with one element, a null element) | null |
<node> <item>2004/12/31</item> </node> | {"2004/12/31"} (String List with one element) | {"2004/12/31"} (Datetime List with one element) | "2004/12/31" |
<node> <item>2004/12/31</item> <item></item> </node> | {"2004/12/31", ""} (String List with two elements) | {"2004/12/31", null} (Datetime List with two elements) | "2004/12/31" |
<node> <item></item> <item>2004/12/31</item> </node> | {"", "123"} (String List with two elements) | {null, "2004/12/31"} (Datetime List with two elements) | null |
<node> <item></item> <item></item> </node> | {"", ""} (String List with two elements) | {null, null} (Datetime List with two elements) | null |
<node> <item>2004/12/31</item> <item> </item> <item></item> <item>2005/01/31</item> </node> | {"2004/12/31", "","", "2006/01/31 "} (String List with four elements) | {"2004/12/31", null,null, "2005/0 1/31"} (Datetime List with four elements) | "2004/12/31" |