下面为您介绍的MySql时间函数用于获取当前时间,该MySql时间函数***实用价值,希望能对您学习MySql时间函数方面有所帮助。
- mysql> select current_timestamp();
- +---------------------+
- | current_timestamp() |
- +---------------------+
- | 2010-01-18 21:24:37 |
- +---------------------+
- 1 row in set (0.00 sec)
- mysql> select current_date();
- +----------------+
- | current_date() |
- +----------------+
- | 2010-01-18 |
- +----------------+
- 1 row in set (0.00 sec)
- mysql> select current_time();
- +----------------+
- | current_time() |
- +----------------+
- | 21:24:46 |
- +----------------+
- 1 row in set (0.00 sec)
【编辑推荐】