Mysql Date Expression

The Tutorial illustrate an example from 'Mysql Date Expression'. To understand this example we use current_timestamp query that return you a format 'YYYY-MM-DD' and 'HH.MM.SS'.

Mysql Date Expression

Mysql Date Expression

     

The Tutorial illustrate an example from 'Mysql Date Expression'. To understand this example we use current_timestamp query that return you a format  'YYYY-MM-DD' and 'HH.MM.SS'. Timestamp columns are displayed in the same format as Datetime format.

Query:-

 

 

 

 

 

 

mysql> select current_timestamp() as Date;

Output:-

+---------------------+
| Date |
+---------------------+
| 2008-12-19 15:38:44 |
+---------------------+
1 row in set (0.00 sec)

Query:-

The now ( ) Query is used to return the current date and time as Date fieldname.

mysql> select now() as Date;

Output:-

+---------------------+
| Date |
+---------------------+
| 2008-12-19 15:39:37 |
+---------------------+
1 row in set (0.00 sec)