Skip to main content Link Menu Expand (external link) Document Search Copy Copied

TIMESTAMP data type

Timestamp is a date-time data type which represents the specified timeunit as integer values elapsed since the specified Unix Epoch.

Before you begin




Argument Description Further information
TIMESTAMP Time and date data type used for time series analysis Time stamp
TIMEUNIT The time unit in which to store a timestamp that defaults to second s See TIMEUNIT values

Additional information


Unit Declaration
seconds (default) s
milliseconds ms
microseconds us
nanoseconds ns


Implicitly convert integer to timestamp

Integer values inserted into a column with timestamp data type are converted to a value of seconds since the beginning of the unix epoch.

Demo table

create table demo
    (_id id, ts timestamp timeunit 's');

insert into demo(_id, ts)
    values (1, 0);
insert into demo(_id, ts)
    values (2, 86400);
insert into demo(_id, ts)
    values (3, 90061);
insert into demo(_id, ts)
    values (4, -86400);

SELECT() statement

select _id, ts from demo;


| _id |           ts                  |
| 1   | 1970-01-01 00:00:00 +0000 UTC |
| 2   | 1970-01-02 00:00:00 +0000 UTC |
| 3   | 1970-01-02 01:01:01 +0000 UTC |
| 4   | 1969-12-31 00:00:00 +0000 UTC |