Report Query time wise issue
Please help someone to solve my problem. Everything is fine except have to mention ahead time approx 5 hours 30 min in query to see the right time report on screen.
The 5 hour and 30 minute offset is exactly the same as India's UTC offset. It sounds like the reports are being generated in UTC instead of UTC+5:30.
It sounds like you may need to define the timezone properly somewhere (likely within Traccar's settings)
Thanks for reply. actually, i know there is some issue with time zone but i am unable to find the place where i need to be define.
Location Coordinates by mobile app (using as tracker) getting feed including server time in database with local time.
I am having the report in excel too as well same on screen based on Route, Event, Trips, stops, summery and charts.
Issue - having report in excel according query based on exact time but I have to set ahead time approx 5 hour 30 minutes to get same report on computer screen.
Like to have report on screen from 10 AM to 11 AM of device location but I have to set time 3:30 PM to 4:30 PM to have same report of device location from 10 AM to 11 AM.