Grafa timefilter function if I input range of timestamp the result is correct but if I input Last xx hour the result is not correct time although I adjust timezone to be UTC +7 in timefilter function in grafana.
The time example as below:
(If current is 2023-10-10 08:00:00 and use Last 1 hour it will show data timestamp between 2023-10-10 00:00:00 - 2023-10-10 01:00:00)
What should I change in my query code and now I use postgresql to be database and column op_timestamp data type is timestamp without timezone
Current query as below:
SELECT
TO_CHAR(op_timestamp,‘YYYY-MM-DD HH:mm:ss’) AS “op_timestamp”,
u_serial_no AS “Serial no”,
delivery_line AS “Delivery line”,
relief_line AS “Relief line”,
delivery_pallet_no AS “jig”,
u_lot_no AS “lot”
FROM “real”
WHERE
$__timeFilter(op_timestamp) AND op_line = ‘1’
ORDER BY op_timestamp