Hello good folks
SELECT eventTimestamp FROM transactions WHERE application = "MyPROD" and eventTimestamp BETWEEN '2020-09-20T10:28:30.186Z' and '2020-09-20T10:28:40.186Z'
I get the data successfully, but the time is exactly 6 hours behind. What t...
hello folks,
I want to basically get count of distinct 'fieldname' .
When I write the following query, it won't work.
SELECT distinctcount(bb) FROM transactions WHERE application = "PROD" AND transactionName = "aaa" AND segments.userData.eReceipt...