Difference between revisions of "MIN()"

From Lianjapedia
Jump to: navigation, search
 
Line 19: Line 19:
 
</code>
 
</code>
  
==Products==
 
Lianja Server, Lianja
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Numeric Data Functions]]
 
[[Category:Numeric Data Functions]]

Latest revision as of 07:26, 23 February 2021

Purpose

Function to return the minimum value

Syntax

MIN(<exp1>, <exp2>)

See Also

AMAX(), AMIN(), IIF(), MAX(), MOD()

Description

The MIN() function returns the lesser of two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types.

Example

? min(1, 3)
         1
? min(ctod("01/02/1997"), date())
01/02/1997