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:

minute($"Date Posted")

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.