timestamp(columnName) elects a
- during a CREATE TABLE operation
- during a SELECT operation
- when ingesting data via InfluxDB Line Protocol, for tables that do not already
exist in QuestDB, partitions are applied automatically by day by default with
Checking if tables contain a designated timestamp column can be done via the
table_columns()functions which are described in the meta functions documentation page.
The native timestamp format used by QuestDB is a Unix timestamp in microsecond resolution. See Timestamps in QuestDB for more details.
Creates a designated timestamp column in
the result of a query. Assigning a timestamp in a
dynamic timestamp) allows for time series operations such as
SAMPLE BY or
LATEST BY on tables which do not have a
The following creates a table with designated timestamp.
The following will query a table and assign a
designated timestamp to the output. Note
the use of brackets to ensure the timestamp clause is applied to the result of
the query instead of the whole
readings table does not have a designated timestamp, we are able
to create one on the fly. Now, we can use this into a subquery to perform
If the data is unordered, it is important to order it first.