Mysql Date Minimum

Mysql Date Minimum return the minimum record value of a date field from a table.

Mysql Date Minimum

Mysql Date Minimum

     

Mysql Date Minimum return the minimum record value of a date field from a table.

Understand with Example

The Tutorial understands you to find the minimum records value of a date field from a table 'employees'. To begin with it, we create a table 'employees' with field attribute and data type respectively.

Query for creating table:-

mysql> CREATE TABLE employees(
-> Empid int(10),
-> Empname varchar(60),
-> date date );

Output:-

Query for inserting data:-

The insert into add the records or rows value into table 'employee1'.

mysql> insert into employee1 values('2','Komal','2008-12-23');
Query OK, 1 row affected (0.03 sec)

mysql> insert into employee1 values('2','Sandeep','2008-12-24');
Query OK, 1 row affected (0.02 sec)

mysql> insert into employee1 values('2','suman','2008-12-25');
Query OK, 1 row affected (0.03 sec)

Query for Viewing data:-

mysql> select * from employee1;

Output:-

+-------+---------+------------+
| Empid | Empname | date       |
+-------+---------+------------+
|     1 | Girish  | 2008-12-20 |
|     2 | Komal   | 2008-12-21 |
|     3 | vineet  | 2008-12-21 |
|     4 | Amit    | 2008-12-20 |
|     2 | Komal   | 2008-12-23 |
|     2 | Sandeep | 2008-12-24 |
|     2 | suman   | 2008-12-25 |
+-------+---------+------------+
7 rows in set (0.00 sec)

Query for finding minimum date from the table:-

The given below Syntax is useful to find out the minimum records or rows value of Date field Name 'date' as Min Date from table employee1.

SYNTAX:-Select Min(DateFieldName) From TableName

mysql> select min(date)as MinDate from employee1;

Output:-

+------------+
| MinDate    |
+------------+
| 2008-12-20 |
+------------+
1 row in set (0.00 sec)