Home Sql Sqldate Mysql Date Minimum
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

Mysql Date Minimum

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

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)
Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 20, 2009

Related Tutorials

Ask Questions?    Discuss: Mysql Date Minimum  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com