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 |