如何恰当的显示月，日；

Question

select month(current_timestamp()); 
得出来是7，怎么能生成07？？？？

Answer 1

mysql> select right(concat('0',month(current_timestamp())),2);
+-------------------------------------------------+
| right(concat('0',month(current_timestamp())),2) |
+-------------------------------------------------+
| 07                                              |
+-------------------------------------------------+
1 row in set (0.00 sec)

Answer 2

本帖最后由 ACMAIN_CHM 于 2012-07-02 08:52:30 编辑

  

Answer 3

select date_format(current_timestamp(),'%m')

Answer 4

select date_format(current_timestamp(),'%m')