"Data points outside time range"

1

Hi Team,

Data Source : postgres

I am just using simple select query and getting message "“Data points outside time range”

SELECT
collection_date AS “time”,
uptime
FROM monitoring.uptime
ORDER BY 1

– Data is getting pushed to Table “monitoring.metric” every min ( Collection_date, Value ).

I am getting error message like ““Data points outside time range””

----------------------------±-----------±-------
2018-12-11 12:55:46.409599 | 2018-10-18 | 54
2018-12-11 12:55:49.73837 | 2018-10-18 | 54
2018-12-11 12:55:53.52063 | 2018-10-18 | 54
2018-12-11 12:55:56.69393 | 2018-10-18 | 54
2018-12-11 12:55:59.569263 | 2018-10-18 | 54
2018-12-11 12:56:01.756 | 2018-10-18 | 54

Note:
i am able to see current Data When i select Quick Range option to 12 Hrs , and there is no ““Data points outside time range”” message.

Seems to be my date column value is getting converted to different timezone ( exactly 8 Hrs delay )

Please guide me to fix timestamp issue.

2

Solution Identified by converting timezone to PST in the select ( Its workaround only )