MSSQL datetime is displayed wrong

Grafana MSSQL
1

Hello,

The Grafana version is * Grafana v8.0.4 (81fef5b4b4) on Ubuntu 18.04.5.
The sql server is MSSQL (64 bit) 13.0.5102.14 on Microsoft Windows NT 6.3 (14393).

I have table panel from mssql. The problem is that when a datetime is ‘2999-12-31 00:00:00’ in sql, the displayed result in Grafana table is ‘1830-11-22 01:50:52’.

You can test it:
SELECT CONVERT(DATETIME, ‘2999-12-31 00:00:00’, 120)

Thanks,

2

This topic was automatically closed after 365 days. New replies are no longer allowed.