Mysql Date Name helps you to find out the current Date of the Month.
Understand with Example
The Tutorial describe a example that help you in find out the current date of the month.
date_format(now( ),'%e') : The Query return you the current date of the month.
Query for selecting date from the current date:-
mysql> select date_format(now(),'%e')as Date;
+------+ | Date | +------+ | 22 | +------+ 1 row in set (0.00 sec)
Posted on: January 20, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles