The Minute function returns an integer representing the minute component of a specified date and time.

Syntax

Minute(date, \[timezone\])

Function arguments:

  • date (required) - the date or column containing date values from which the minute component is extracted
  • timezone (optional) - the IANA time zone (e.g., β€œAmerica/Los_Angeles”) to convert the date value to before extracting the minute component

πŸ“˜

When the timezone argument is omitted, the input date is evaluated in UTC time.

Example

Minute(Date("2007-08-14 07:11:00"))

Extracts the minute component from the specified date and time and returns 11 to represent the eleventh day of the month.