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