Time & SLEEP
TIME retrieves and formats date/time values. SLEEP pauses execution. !NOW gives the current Unix timestamp fixed at query start.
| Verb / Variable | Description |
|---|---|
TIME SET ?ts | Current Unix timestamp (number) |
TIME NOW AS "format" | Current time formatted |
TIME "iso-string" AS "format" | Parse and reformat an ISO date string |
!NOW | Immutable — current Unix timestamp fixed at query start |
SLEEP "duration" | Pause execution: "1s", "500ms", "2m", "1h" |
TIME — current timestamp
TIME SET ?ts
AFTER EMIT ?ts
Try it ›
TIME NOW AS "format"
| Format string | Returns |
|---|---|
"date" | YYYY-MM-DD |
"time" | HH:MM:SS |
"datetime" | YYYY-MM-DD HH:MM:SS |
"iso" | ISO 8601 full format |
"year" | 4-digit year |
"month" | 2-digit month (01-12) |
"day" | 2-digit day (01-31) |
"hour" | 2-digit hour (00-23) |
"minute" | 2-digit minute |
"second" | 2-digit second |
"day-name" | Monday, Tuesday, ... |
"month-name" | January, February, ... |
"week" | Week number of year |
"unix" | Unix timestamp as text |
TIME NOW AS "date" SET ?d
AFTER TIME NOW AS "day-name" SET ?dn
AFTER EMIT ?dn & ", " & ?d
Try it ›
TIME from ISO string
TIME "2026-01-15T00:00:00Z" AS "day-name" SET ?d
AFTER EMIT ?d
Try it ›
!NOW — fixed timestamp
!NOW is set once at query start. Use it when you need the same timestamp across multiple steps.
WRITE "log entry" INTO "/root/logs/" & !NOW & ".txt"
AFTER EMIT "Saved at: " & !NOW
Try it ›
SLEEP
EMIT "Starting..."
AFTER SLEEP "1s"
AFTER EMIT "Done after 1 second"
Try it ›
Duration formats:
"500ms", "1s", "2m", "1h". SLEEP counts against your query timeout.