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

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

python - Pygame screen.blit not working -

c# - Web API response xml language -