time

Track current date and time in the system.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: time

  • Windows

  • Linux

  • Mac OSX

  • Free BSD

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.

Query examples

Select all the results for the given table.

SELECT * FROM time;