在SQL中查询加时间条件查询没有问题,SQL语句如下 select convert(decimal(18,2),sum(expense)) as yhje from membersale where dt>='2015-05-09 07:37:00:396' and dt<='2015-05-10 07:37:00:396'; 在finereport数据集中增加参数不是查不出数来,参数类型设置为日期型,设置如下图 select convert(decimal(18,2),sum(expense)) as yhje from membersale where dt>='${starttime}' and dt<='${endtime}' |
最佳回答 |
||||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|
|||
0
|
|