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)
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
