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

Syntax

TIMESTAMP [TIMEUNIT {value}]

Arguments

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

TIMEUNIT value

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

Examples

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;

Results

| _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 |