Edit

make_timespan()

  • Article

Creates a timespan scalar value from the specified time period.

Syntax

make_timespan(hour, minute)

make_timespan(hour, minute, second)

make_timespan(day, hour, minute, second)

Learn more about syntax conventions.

Parameters

Name Type Required Description
day int ✔️ The day.
hour int ✔️ The hour. A value from 0-23.
minute int The minute. A value from 0-59.
second real The second. A value from 0 to 59.9999999.

Returns

If the creation is successful, the result will be a timespan value. Otherwise, the result will be null.

Example

Run the query

print ['timespan'] = make_timespan(1,12,30,55.123)

Output

timespan
1.12:30:55.1230000