cast转换

[rainbowliuliang]

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...这样的 如何解决

[tim_spac]

mysql> select @@version;
+---------------------+
| @@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 |
+---------------------+-----------------------+-------------+

[rainbowliuliang]

.....
难道是我的mysql版本的问题。。。

[DaiLM]

不太清楚，是不是postgre里没有默认的函数支持这种操作？需要自己写个函数？

我在我的8.1上试了下，没有curdate()函数，只能用current_date，所以感觉和版本也有一定的关系。。。吧

[rainbowliuliang]

补充 mysql 5.2.0