Hi Team can someone please explain this scenario where if i am executing 2 queries which logically means the same based on date flilter i am getting the results as different • For 1st it gives output within the ask range • For the 2nd it gives output of records +5:30 date range Is there some timezone setting which we have to setup Inherently in the payload the dateTime is always in IST Query 1

SELECT recordId,
identityElement,
transactionDate
                FROM table1
                WHERE trailId = 'xyz'
                  AND partnerId = 'zyr'
				  AND reconcilableAttribute = 'kk'
                  AND transactionDate >= '2025-06-03 00:00:00'
                  AND transactionDate < '2025-06-03 01:00:00'
			
order by transactionDate asc;
				 

results
"rows": [
      [
        "record1",
        "tid1",
        "2025-06-03 00:00:00.0"
      ]

Query2

SELECT
        recordId,
        updatedAt,
		identityElement,
        transactionDate,
        ROW_NUMBER() OVER (PARTITION BY recordId ORDER BY updatedAt ASC) AS rn
    FROM
        orbis_baggage
    WHERE
        trailId = 'xyz'
        AND partnerId = 'zyr'
        AND reconcilableAttribute = 'TOTAL_AMOUNT'
        AND transactionDate >= '2025-06-03 00:00:00'
        AND transactionDate < '2025-06-03 01:00:00'
		order by transactionDate asc

result :
[
        "record2",
        "tide2",
        "2025-06-03 05:30:00.0",
        1
      ],