Mysql Date Part Only

Sometimes we want to see the date part only from the records of a table. The Tutorial covers you an example that helps you to get date part. The date(now( )) return you the current date as date field name.

date (now( ) ) : The date(now ( )) return you the current date. 

Query:-

mysql> select date(now())as date;

Output:-

+------------+
| date       |
+------------+
| 2008-12-22 |
+------------+
1 row in set (0.00 sec)

Related Tags for Mysql Date Part Only:

More Tutorials from this section

• SQL Date, SQL Date Examples
• SQL Date
• MySQL By Date
• MySQL By Week
• Mysql date API
• Mysql Date Arithmetic
• Mysql Date in between
• Mysql Date Default
• Mysql date equal
• Mysql date field
• Mysql Date Filter
• Mysql Date Format codes
• Mysql Date Format Convert
• Mysql Date Format
• Mysql Date from Date
• Mysql Date and Time
• Mysql Date Functions
• Mysql Date Index
• Mysql Date Input
• Mysql Date To Java Date

Ask Questions?    Discuss: Mysql Date Part Only  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):