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

Query examples

Select all the results for the given table.

SELECT * FROM time;