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
Post a Comment