select now(),cast(now() as signed),curdate()+1;查询结果 ( 1 条记录 )
now() cast(now() as signed) curdate()+1
2008-02-15 10:21:26 2008 20080216
cast(now() as signed) 的结果不是我想要的 我认为该是 20080215...这样的 如何解决
now() cast(now() as signed) curdate()+1
2008-02-15 10:21:26 2008 20080216
cast(now() as signed) 的结果不是我想要的 我认为该是 20080215...这样的 如何解决
+---------------------+
| @@version |
+---------------------+
| 5.0.45-community-nt |
+---------------------+
mysql> select now(),cast(now() as signed), curdate()+1;
+---------------------+-----------------------+-------------+
| now() | cast(now() as signed) | curdate()+1 |
+---------------------+-----------------------+-------------+
| 2008-02-15 15:01:35 | 20080215150135 | 20080216 |
+---------------------+-----------------------+-------------+
难道是我的mysql版本的问题