timeseries / qstudio

qStudio - Free SQL Analysis Tool
https://www.timestored.com/qstudio/
Apache License 2.0
416 stars 17 forks source link

duckdb time column doesn't show as time in graph #29

Closed ryanhamilton closed 3 months ago

ryanhamilton commented 3 months ago

SELECT  * FROM    ( VALUES
        (TIMETZ '1992-09-20 11:30:00.123456', 2),
        (TIMETZ '1992-09-20 11:32:00.123456', 3),
        (TIMETZ '1992-09-20 11:33:01.123456', 3),
        ) AS q (t,v)

SELECT  * FROM    ( VALUES
        (TIME '1992-09-20 11:30:00.123456', 2),
        (TIME '1992-09-20 11:32:00.123456', 3),
        (TIME '1992-09-20 11:33:01.123456', 3),
        ) AS q (t,v)        

SELECT TIMESTAMP_NS '1992-09-20 11:30:00.123456789',1; -- 1992-09-20 11:30:00.123456
SELECT TIMESTAMP    '1992-09-20 11:30:00.123456789',1; -- 1992-09-20 11:30:00.123456
SELECT DATETIME     '1992-09-20 11:30:00.123456789',1; -- 1992-09-20 11:30:00.123456
SELECT TIMESTAMP_MS '1992-09-20 11:30:00.123456789',1; -- 1992-09-20 11:30:00.123
SELECT TIMESTAMP_S  '1992-09-20 11:30:00.123456789',1; -- 1992-09-20 11:30:00
SELECT TIMESTAMPTZ  '1992-09-20 11:30:00.123456789',1; -- 1992-09-20 11:30:00.123456+00
SELECT TIMESTAMP WITH TIME ZONE '1992-09-20 11:30:00.123456789',1; -- 1992-09-20 11:30:00.123456+00
SELECT DATE '1992-09-20',2;

image

ryanhamilton commented 3 months ago

Fixed

image