编译错误啊。提示:
14:23:44 [SELECT - 0 row(s), 0.000 secs] [Error Code: -9700, SQL State: IX000] Routine (to_number) ambiguous - more than one routine resolves to given signature.
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
是 oracle 数据库么?
追问是imformix。一直减不出来啊
追答如果直接两个日期相减。informix 会得到什么结果?
-----------------------------
试一试 select outdate,indate from table date(outdate) - date(indate) <1
首先非常感谢你。
我的问题是,table表下面有两个字段indate,outdate。其字段格式都是“DATETIME YEAR TO SECOND” 比如显示的值是“2012-05-30 17:55:29.0”
现在需求是,选outdate里面最大的减去indate里面最小的,小于24小时。就是outdate-indate<=24。我研究很久了,没弄出来。.求高人指点