Timezone query NOT returning results


I am querying sales for a shop in Singapore. The timezone is UTC + 8

When I query at UTC + 0 it returns results - however the sales times are wrong (obviously).


When the query is amended to include the correct timezone (+0800), the results are null / 0 - which is definitely incorrect - there are 100% sales in the period:


What is happening here?

1 comment

Sign In or Register to comment.