Time column parsing error

[kkevvai]

Describe the bug
I'm trying to run the following query

SELECT
  *
FROM
  mytable

where one or more columns in 'mytable' have the following format:
YYYY-MM-DDTHH:mm:ss.[milliseconds] e.g. , 2024-03-11T20:14:34.360
The following error is thrown in Grafana:
parsing time "2024-03-11T00:00:00Z": extra text: "T00:00:00Z"
Note:
When querying via,e.g, Tableau or JMP, these columns are parsed correctly.
Workaround:
STRING(timestamp_column) fixes the issue. However, I'd have to explicitly apply the STRING function for each appropriate column (these may not always be known).

Expected behavior
Timestamp columns are interpreted properly.

Screenshots

Environment:
Plugin Version: 1.3.0
Grafana Version: v11.1.0

[mullerpeter]

Hey @kkevvai

Thanks for opening the issue, but I'm not really able to reproduce the error you are getting.

Can you try to create a simple debug table like I do and tell me if the same error still happens? Or run a DESCRIBE TABLE and tell me the data type of your timestamp column which is not working?

CREATE TABLE debug (id INT, ts TIMESTAMP, value INT);

INSERT INTO debug VALUES
    (1, '2024-11-09T10:10:00.123456', 1),
    (2, '2024-11-09T10:11:02.323456', 2),
    (3, '2024-03-11T20:14:34.360', 3),
    (4, '2024-03-11T00:00:00Z', 4);

SELECT * FROM debug;