Guest User

Untitled

a guest
Jan 19th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. xdmp:parse-dateTime("[Y0001]-[M01]-[D01]T[H01]:[m01]:[s01]","2017-01-17T08:00:00")
  2. xdmp:parse-dateTime("[Y0001]-[M01]-[D01]T[H01]:[m01]:[s01]","2017-01-17T22:45:00")
  3.  
  4. xquery version "0.9-ml"
  5. fn:subtract-dateTimes-yielding-dayTimeDuration(
  6. xdmp:parse-dateTime("[Y0001]-[M01]-[D01]T[H01]:[m01]:[s01]","2017-01-17T08:00:00"),
  7. xdmp:parse-dateTime("[Y0001]-[M01]-[D01]T[H01]:[m01]:[s01]","2017-01-17T22:45:00")
  8. )
  9.  
  10. -PT14H45M
  11.  
  12. let $date1 := xs:dateTime("2017-01-17T08:00:00")
  13. let $date2 := xs:dateTime("2017-01-17T22:45:00")
  14. return fn:abs(($date1 - $date2) div xs:dayTimeDuration("PT1M"))
  15.  
  16. xquery version "1.0-ml";
  17. import module namespace functx = "http://www.functx.com" at
  18. "/MarkLogic/functx/functx-1.0-nodoc-2007-01.xqy";
  19.  
  20. functx:total-minutes-from-duration(
  21. xdmp:parse-dateTime("[Y0001]-[M01]-[D01]T[H01]:[m01]:[s01]","2017-01-17T08:00:00")
  22. - xdmp:parse-dateTime("[Y0001]-[M01]-[D01]T[H01]:[m01]:[s01]","2017-01-17T22:45:00")
  23. )
Add Comment
Please, Sign In to add comment