min min

Returns the minimum value among a set of expressions, given either as a list or two expressions. Null values are ignored.

Category

Aggregation

Function syntax

min(<parameters>)

Parameters

  • listDuration
  • listInteger
  • listDecimal
  • listDateTime
  • listDateTimeOnly
  • listDateOnly
  • duration
  • integer
  • decimal
  • dateTime
  • dateTimeOnly

Signatures and returned types

min(<listDuration>)

Returns a duration.

min(<listInteger>)

Returns a duration.

min(<listDateTimeOnly>)

Returns a datetime without considering time zone.

min(<listDateTime>)

Returns a datetime.

min(<listDateOnly>)

Returns a date.

min(<listDecimal>)

Returns a decimal.

min(<decimal>,<decimal>)

Returns a decimal.

min(<duration>,<duration>)

Returns a duration.

min(<dateTime>,<dateTime>)

Returns a datetime.

min(<dateTimeOnly>,<dateTimeOnly>)

Returns a datetime without considering time zone.

min(<integer>,<integer>)

Returns an integer.

Examples

min(@{BarBeacon.inventory},5)

min([10,3,8])

Returns 3.

min([10,null,8])

Returns 8.

recommendation-more-help
4f4a00c1-77c9-4eee-84df-bbe6206c3ab9