Sybase Adaptive Server Anywhere - Page 366

Alphabetical list of functions
348
MIN function [Aggregate]
Returns the minimum expression value found in each group of rows.
MIN ( expression
| DISTINCT column name )
expression The expression for which the minimum value is to be
calculated. This is commonly a column name.
DISTINCT column-name Returns the same as MIN( expression ), and is
included for completeness.
The following statement returns the value 24903.000, representing the
minimum salary in the employee table.
SELECT MIN( salary )
FROM employee
Rows where expression is NULL are ignored. Returns NULL for a group
containing no rows.
♦
SQL/92 SQL/92 compatible.
♦
Sybase Compatible with Adaptive Server Enterprise.
"MAX function" on page 347
MINUTE function [Date and time]
Returns a number from 0 to 59 corresponding to the minute component of a
datetime value.
MINUTE ( datetime-expression )
datetime-expression The datetime value.
The following statement returns the value 22.
SELECT MINUTE( ’1998-07-13 12:22:34’ )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
MINUTES function [Date and time]
Returns the number of minutes since an arbitrary date and time, between two
specified times or adds the specified integer-expression amount of minutes to
a time.
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
Function