The time function composes a time starting from hours, minutes and seconds strings.
While the hour function extracts the time from a datetime attribute, the time function builds the time by merging strings coming from different columns.
time(hour, minute, second)
The attribute containing the hour as an integer number. The hour parameter is mandatory.
The attribute containing the minute as an integer number.
The attribute containing the second as a continuous number.
The following example uses the Instagram_data dataset.
In this example, we want to create a new attribute which merges the Hour and Minute attributes.
We add a new attribute, called Time, and type the following formula:
and the attribute is filled with the time.