Code: Select all
mysql> show variables like '%format%';
+---------------------+-------------------+
| Variable_name | Value |
+---------------------+-------------------+
| date_format | %d-%m-%Y |
| datetime_format | %d-%m-%Y %H-%i-%s |
| default_week_format | 0 |
| time_format | %H:%i:%s |
+---------------------+-------------------+
4 rows in set
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2006-05-03 15:17:50 |
+---------------------+
1 row in set
mysql> select curdate();
+------------+
| curdate() |
+------------+
| 2006-05-03 |
+------------+