Skip to main content
Enterprise Support Available
Spice.ai Enterprise provides full support for up to 3 years from the release date.
Version: v1.10

Duration

Durations are represented as a number with a time unit suffix. A value without a suffix is interpreted as seconds, and fractional values (e.g. 1.5h) are accepted.

Supported time units are:

Time UnitIdentifierCalculation
Nanosecondns1
Millisecondms1000000
Seconds1s
Minutem60s
Hourh60m
Dayd24h
Weekw7d

Microseconds are also supported, spelled Ms (capital M, lowercase s).

Month and year units are not supported — their length is ambiguous, so express longer intervals in weeks or days.

Example​

# 1 second
1s

# 250 milliseconds
250ms

# 3 minutes
3m

# 1 hour
1h

Additional Example​

# 2 days
2d

# 1 week
1w

# 90 minutes
1.5h

# 30 seconds (no suffix)
30