Mysql Date Name

Ads
 

Mysql Date Name

Mysql Date Name helps you to find out the current Date of the Month.

Mysql Date Name helps you to find out the current Date of the Month.

Mysql Date Name

     

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;

Output:-

+------+
| Date |
+------+
| 22   |
+------+
1 row in set (0.00 sec)

Ads

Ads