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. .. code-block:: sql SELECT * FROM time;