[an error occurred while processing this directive]

Mysql Date and Time

                         

The Tutorial illustrate an example, that help in understanding datetime. In this Tutorial ,we illustrate an example that help you in writing a date time format Query in different ways.

now ( )  :The below Query return you the current date in yyyy-mm-dd and time in hh:mm:ss.

Query for displaying current date and time:-

 

 

 

 

 

mysql> select now()as DateandTime;

Output:-

+---------------------+
| DateandTime |
+---------------------+
| 2008-12-20 12:19:07 |
+---------------------+
1 row in set (0.00 sec)

Query for extracting date from datetime:-

The given below Query return you the current date.

mysql> select day(now())as TodayDate;

Output:-

+-----------+
| TodayDate |
+-----------+
| 20 |
+-----------+
1 row in set (0.00 sec)

                         

[an error occurred while processing this directive]