Monday, 25 February 2013

xQuery: How to ADD or Subtract hours from DateTime



 How to ADD or Subtract hours from DateTime

xs:dateTime("1999-12-31T23:00:00") + xdt:dayTimeDuration("PT2H")

xs:dateTime("1999-12-31T23:00:00") + xdt:dayTimeDuration("PT2H")

You can use the below expression for adding 1 day (24 hrs) to a given current date:

fn:current-dateTime() + xdt:dayTimeDuration("PT24H")