解析日期字符串

Question

我试过这个：

xdmp:parse-dateTime("[D01]-[MN,*-3]-[Y0001]","12-FEB-2014")

但它抛出了一个异常：

XDMP-PATTERNVALUEMISMATCH: Given value doesn't match with the specified pattern
for parsing dateTime string

Answer 1

看起来你有一个月的时间，你必须制作你自己的转换函数。下面的代码应该会给你一个开始。它将按照你给我们的例子工作。

declare function local:month-name-to-int
  ( $stringIN as xs:string? )  as xs:string? {
   switch (fn:lower-case($stringIN))
   case "jan" return "01"
   case "feb" return "02"
   case "mar" return "03"
   case "apr" return "04"
   case "may" return "05"
   case "jun" return "06"
   case "jul" return "07"
   case "aug" return "08"
   case "sep" return "09"
   case "oct" return "10"
   case "nov" return "11"
   case "dec" return "12"
   default return fn:error(xs:QName("ERROR"), "unknown month")
 } ;

let $string := "12-FEb-2014"
let $stringTokened := fn:tokenize($string, "-")
return xs:date($stringTokened[3] || "-"||local:month-name-to-int($stringTokened[2]) || "-" || $stringTokened[1])