The following list shows valid time units for the
WITHIN clauses, or to pass as time unit parameters in functions.
For more information, see Windows in SQL Queries.
This section refers to timestamps as a field in records. For information on the TIMESTAMP data type, see Timestamp types.
Time-based operations, like windowing, process records according to the
ROWTIME. By default, the implicit
ROWTIME pseudo column is the
timestamp of a message in a Kafka topic. Timestamps have an accuracy of
Use the TIMESTAMP property to override
ROWTIME with the contents of
the specified column. Define the format of a record's timestamp by
using the TIMESTAMP_FORMAT property.
If you use the TIMESTAMP property but don't set TIMESTAMP_FORMAT, ksqlDB
assumes that the timestamp field is either a
bigint or a
If you set TIMESTAMP_FORMAT, the TIMESTAMP field must be of type
and have a format that the
DateTimeFormatter Java class can parse.
If your timestamp format has embedded single quotes, you can escape them
by using two successive single quotes,
''. For example, to escape
''T''. The following examples show how to escape the
character in SQL statements.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
For more information on timestamp formats, see DateTimeFormatter.