minute function
The minute function returns the minute value of time.
Parameters
minute(time)
Parameter | Description |
---|---|
time | The datetime or time attribute from which we want to retrieve the minute. 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 |
---|---|
Suppose that you don’t have already the Minute attribute in the dataset, and you want to retrieve the minute from the Date Posted attribute. Add a new attribute, called New Minute, and type the following formula:
and the attribute will be filled with the minute values of the Date Posted attribute. You can use the existing Minute attribute to double check the results. |