Attention
Zercurity has been acquired by JumpCloud.
This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.
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 |