sudheshna iyer wrote:

I need a xquery function which takes two dates and return number of days
that lapsed between these two dates. Input to this function can be a 2
strings of type "mm/dd/yyyy 00:00:00".

Can any of you have a function handy to do this?

Well there is an xs:dateTime data type supporting this:

days-from-duration(current-dateTime() - xs:dateTime('2013-01-01T00:00:00'))



You would first need to convert your date time format to the xs:dateTime format of yyyy-mm-ddThh:mm:ss respectively construct xs:dateTime values from your format.
_______________________________________________
[email protected]
http://x-query.com/mailman/listinfo/talk

Reply via email to