time

Track current date and time in the system.

Table schema

Name Type Description
weekday TEXT Current weekday in the system
year INTEGER Current year in the system
month INTEGER Current month in the system
day INTEGER Current day in the system
hour INTEGER Current hour in the system
minutes INTEGER Current minutes in the system
seconds INTEGER Current seconds in the system
timezone TEXT Current timezone in the system
local_time INTEGER Current local UNIX time in the system
local_timezone TEXT Current local timezone in the system
unix_time INTEGER Current UNIX time in the system, converted to UTC if –utc enabled
timestamp TEXT Current timestamp (log format) in the system
datetime TEXT Current date and time (ISO format) in the system
iso_8601 TEXT Current time (ISO format) in the system
win_timestamp BIGINT Timestamp value in 100 nanosecond units.