Date functions

Minute

View as MarkdownOpen in Claude

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 minute of the hour.