Time examples

CREATE TAG TABLE IF NOT EXISTS EXAMPLE (
    NAME VARCHAR(20) PRIMARY KEY,
    TIME DATETIME BASETIME,
    VALUE DOUBLE SUMMARIZED
);
INSERT INTO EXAMPLE VALUES('TAG0', TO_DATE('2021-08-12 12:00:00 123:456:789'), 10);
INSERT INTO EXAMPLE VALUES('TAG0', TO_DATE('2021-08-13 12:00:00 123:456:789'), 11);

SQL(`select to_char(time), value from example where time < ?`, time('now'))
CSV()

SQL(`select to_char(time), value from example where time = ?`, time(1628737200123456789))
CSV()

STRING(param("format_time") ?? "808210800", separator('\n'))
SCRIPT("js", {
    epoch = parseInt($.values[0])
    time = new Date(epoch*1000)
    $.yield(epoch, time.toISOString())
})
CSV()

STRING(param("timestamp") ?? "1995-08-12T00:00:00.000Z", separator('\n'))
SCRIPT("js", {
    ts = new Date(Date.parse($.values[0]));
    epoch = ts.getTime() / 1000;
    $.yield(epoch, ts.toISOString())
})
CSV()

SQL(`select to_char(time), time from example`)
CSV()

SQL(`select to_char(time), time from example`)
CSV(timeformat('DEFAULT'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('NUMERIC'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('ANSIC'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('NUMERIC'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('RFC822'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('RFC3339'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('DEFAULT'), tz('local'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('DEFAULT'), tz('UTC'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('DEFAULT'), tz('Asia/Seoul'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('DEFAULT'), tz('EST'))

SQL(`select to_char(time), time from example`)
CSV(timeformat('DEFAULT'), tz('Europe/Paris'))