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")


Posted by at

4 comments:

  1. milky15 June 2016 at 06:40

    This comment has been removed by the author.

    ReplyDelete
  2. milky15 June 2016 at 07:01

    very good post. It helped me :)

    ReplyDelete
  3. Unknown17 November 2017 at 01:57

    Sure, Mpho....

    Man you helped me.....

    ReplyDelete
  4. Sanddy21 December 2017 at 21:33

    How to substract 1 day from current date ?

    ReplyDelete

Subscribe to: Post Comments (Atom)