xquery - UTC time zones calculation -


departuredatetime:2015-08-15t09:50:00 (gmtoffset=10)

arrivaldatetime:2015-08-15t06:30:00(gmtoffset=-7)

flightduration= arrivaldatetime-departuredatetime flithtduration =13:40 hours, giving,

but how calculating unable understand, according formula giving 13:40 hours,could pls , explain.

thanks in advance.

2015-08-15t09:50:00 (gmtoffset=10) = 2015-08-14t23:50:00z

2015-08-15t06:30:00(gmtoffset=-7) = 2015-08-15t13:30:00z

= 13h40m

i think need brush on time zone concepts bit, because there's nothing wrong calculation itself. if you're feeding bad data return bad results.


Comments

Popular posts from this blog

php - Admin SDK -- get information about the group -

dns - How To Use Custom Nameserver On Free Cloudflare? -

Python Error - TypeError: input expected at most 1 arguments, got 3 -