XQuery - How to get 90 days to date from a specific date?

Question

In xquery, how to get 90 days before a date from a specific date?

Tell the given date 30-03-2012. I want to get a date that is 90 days before a specified date. You cannot also skip the billing year.

I couldn't find any built in functions. There are add / substract methods, but they only work on two dates.

Any ideas?

+3

Radhika 29 Mar 12 at 20:29

1 answer

Gunther · Accepted Answer · 2012-03-29T21:07:10+0000

You need to subtract the dayTimeDuration (90 days) from the date i.e.

xs:date("2012-03-30") - xs:dayTimeDuration("P90D")