Timezone doesn't seem correct

Hi,
We’ve set the timezone in account settings to Los Angeles, but the picks/packs etc timestamps in API query results don’t seem to reflect our working hours. Is there anything we can do to fix that?
Thank you!

Hey @Raj,

Happy Friday and thanks for reaching out!
Let me investigate further and I’ll get back to you with an update.

Best,
RayanP

Hey @Raj,

This is a known issue making its way to our Engineering Team. I’ll give it a bump to try and push it along.

Please let me know if you have any questions or concerns, thanks!

Best,

Thank you @Rayanp, I appreciate the updates. I hope it’s resolved soon.

Also @Rayanp, in the meantime would you be able to tell me what timezone are the query results shown in?
Thank you!

Hey @Raj,

The query results are intended to display in UTC. However, this issue is causing the results to be offset by a random amount of time. We’re unable to discern what the cause of this issue is at the time and hoping that our Engineering Team could shed some light on that.

Please let me know if this was unclear or if you have any more questions!

Best,
RayanP

Hey @Rayanp,
Ohh that’s worse than I thought… but still good to know that’s what the problem is. I hope your engineers are able to figure this one out quick, as this is throwing off all our performance reports right now.
Thank you

1 Like

Hey @Rayanp, any update here pls?
Hi @tomasfd, maybe you could have a look into this too?

Thank you guys!

Hey @Raj!

Engineers have been working on the issue this past week, they have a fix coming up soon.

Best,
TomasFD

Thank you @tomasfd! That’s great to know - really looking forward to it :smiley:

Hey @Raj,

A fix has been rolled out for this issue.
Please let me know if you run into any problems on your end!

Best,
RayanP

Wow that’s great news! Thank you @Rayanp
QQ - Does the fix mean that the timestamp would now follow the timezone set in account settings? Or would that be UTC?

Hey @Raj,

I believe that should be in UTC as well.

Best,
RayanP

Hi @Rayanp ,
I have been trying it out and the good news is that reported timestamps do seem to accurately reflect UTC time.

But can you pls confirm what timezone are the timestamps in my queries interpreted in?
Say if I use a date_from value of “2022-07-11 13:58:34”, then is that interpreted to be in:
a) My computer’s timezone
b) Timezone set in SH account settings
c) UTC

Pls note all of the above are different for me right now. And I’m trying to query the number of shipments made on a date and the number doesn’t match what’s shown in dashboard - so I’m trying to resolve any timezone related issues.

Thank you!

Hello @Raj!

That would be option B from your list.

If you are running into discrepancies, please let me know.

Best!
TomasFD

Thank you @tomasfd, though going through some results it seems that when I convert local time to UTC and use those as timeframes in my query, then the results match what I see in the online dashboard - which would mean that the option C would be correct