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