The timespan data type

The timespan (time) data type represents a time interval.

timespan literals

Literals of type timespan have the syntax timespan(value), where a number of formats are supported for value, as indicated by the following table:

Valuelength of time
2d2 days
1.5h1.5 hour
30m30 minutes
10s10 seconds
time(15 seconds)15 seconds
0.1s0.1 second