pb数据窗口,怎么将datetime时间变量传到setfilter中
【详细描述】
我想做个报表 用数据窗口来做 检索的时候能具体检索到某个月 一直不成功 上网找了很久也找不到正确答案~~`
int ll
datetime kk
kk=datetime(today()) -----将将当天时间转换成datatime格式 2010-03-07 00:00:00
ll=dw_1.setfilter("starttime > kk") -----不行
ll=dw_1.setfilter("starttime > '+string(kk)+'") -----不行 类型不匹配
ll=dw_1.setfilter("starttime > '+kk+'") -----不行 类型不匹配
+---------+---------------------+---------------------+-------------+----------------+
| tableid | starttime | endtime | gamefeerate | gamepricetotal |
+---------+---------------------+---------------------+-------------+----------------+
| 1 | 2010-03-07 13:56:28 | 2010-03-07 13:56:30 | 6 | 0 |
| 1 | 2010-03-07 13:56:11 | 2010-03-07 13:56:12 | 6 | 0 |
| 1 | 2010-03-07 01:57:28 | 2010-03-07 01:57:30 | 6 | 0 |
| 1 | 2010-03-07 00:45:16 | 2010-03-07 01:57:23 | 6 | 7.2 |
| 1 | 2010-03-07 00:40:32 | 2010-03-07 00:40:50 | 6 | 0 |
| 1 | 2010-03-07 00:01:13 | 2010-03-07 00:01:18 | 6 | 0 |
+---------+---------------------+---------------------+-------------+----------------+
[解决办法]
ll=dw_1.setfilter("string(starttime,'yyyy-mm-dd') > '" +string(kk,'yyyy-mm-dd')+ "'")
确定可以~~
