hour function
The hour function returns the hour value of time.
Parameters
hour(time)
Parameter | Description |
---|---|
time | The datetime or time attribute from which we want to retrieve the time. The time parameter is mandatory. |
Datetime type valid formats (if the values aren’t this format, the function will return an error).
2019/05/22 17:33:45
Time type valid formats (if the values aren’t this format, the function will return an error).
17:27:35;
17:27:35.120;
17:27
Example
The following example uses the Instagram_data dataset.
Description | Screenshot |
---|---|
In this example, we want to create a new attribute with the hour the posts were created, which is now contained in the Date Posted attribute. We create a new attribute, called hour function, and write the following formula:
and the attribute will be filled with the hour only. |