The different types of time data in MySQL :TIME, DATE TIME and TIMESTAMP. The Tutorial helps you to write the Date Format in SQL Query.

Mysql Date Format

     

The different types of time data in MySQL :TIME, DATE TIME and TIMESTAMP. The Tutorial helps you to write the Date Format in SQL Query. 

date_format(now( ),'%e %M%W%Y') : This Query is used to display the current date, month, week and year. 

Query for formatting currentdate:-

mysql> select date_format(now(),'%e %M %W %Y');

Output:-

+----------------------------------+ | date_format(now(),'%e %M %W %Y') | +----------------------------------+ | 20 December Saturday 2008 | +----------------------------------+ 1 row in set (0.00 sec)

Related Tags for Mysql Date Format:

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