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. |