Timezone query NOT returning results

Hi,


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).

https://api.lightspeedapp.com/API/Account/194484/Sale.json?&offset=0&limit=100&timeStamp=%3E%3C,2019-07-17T00:00:00-0000,2019-07-19T00:00:00-0000&load_relations=[%22SaleLines%22,%20%22SalePayments%22,%20%22SalePayments.PaymentType%22] 



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:


https://api.lightspeedapp.com/API/Account/194484/Sale.json?&offset=0&limit=100&timeStamp=%3E%3C,2019-07-17T00:00:00+0800,2019-07-19T00:00:00+0800&load_relations=[%22SaleLines%22,%20%22SalePayments%22,%20%22SalePayments.PaymentType%22]


What is happening here?


1 comment

Sign In or Register to comment.