Tag: mysql min of two values

MySQL MINUTE Function

Example

Return the minute part of a datetime value:

SELECT MINUTE("2017-06-20 09:34:00");

Definition and Usage

The MINUTE() function returns the minute part of a time/datetime (from 0 to 59).

Syntax

MINUTE(datetime)

Continue reading MySQL MINUTE Function

MySQL MIN Function

Example

Find the price of the cheapest product in the “Products” table:

SELECT MIN(Price) AS SmallestPrice FROM Products;

Definition and Usage

The MIN() function returns the minimum value in a set of values.

Note: See also the MAX() function. Continue reading MySQL MIN Function