任何在KSQL中把datetime类型的转换成date类型的？

hxqsys

需要查找前30天的记录，请老师帮忙看看这个KSQL语句怎么写？
KSQL：
select Tbl_edu_cust.*,Tbl_eduCustState.*
    from Tbl_edu_cust Tbl_edu_cust
     optional  join Tbl_eduCustState Tbl_eduCustState on Tbl_edu_cust = Tbl_eduCustState.fLinkManID
    where :toDate( Tbl_eduCustState.fContactTime) = :MoreDays_A
JS：
MoreDaysActivity.listDataRefreshCreateParam = function(event){
  var datetime = justep.System.datetime();
  var MoreDays = justep.Date.decrease(datetime,30,'d');
  var MoreDays_A = MoreDays.toDateString();
  var map = new justep.Request.MapParam();
  map.put("MoreDays_A",MoreDays_A);
  event.param.setMap("variables", map);  
};



Caused by: com.justep.model.exception.ModelException: 执行ksql:SELECT Tbl_edu_cust.*,Tbl_eduCustState.*  FROM Tbl_edu_cust Tbl_edu_cust  optional  join Tbl_eduCustState Tbl_eduCustState on Tbl_edu_cust = Tbl_eduCustState.fLinkManID WHERE (:toDate( Tbl_eduCustState.fContactTime ) = :MoreDaysA) LIMIT 0, 20时出错！
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 25 more
Caused by: com.justep.model.exception.ModelException: 执行函数是出错：toDate
at com.justep.system.ksql.parser.ExpressionImpl.functionExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parameterNode(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.constExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.addExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.compExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.notExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.andExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.orExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.conditionExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.whereExpression(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 30 more
Caused by: com.justep.system.ksql.matcher.TokenMatchException: bl_eduCustState^^.fContactTime ) 中未找到需要的token, 位置：201 需要下列之一：(
at com.justep.system.ksql.token.TokenManager.matchToken(Unknown Source)
at com.justep.system.ksql.token.TokenManager.matched(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.functionExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.constExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.unaryExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.multiExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.addExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.compExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.notExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.andExpression(Unknown Source)
at com.justep.system.ksql.parser.ExpressionImpl.orExpression(Unknown Source)
... 53 more

fpj

where :toDate( Tbl_eduCustState.fContactTime) = :MoreDays_A

改成

where :getDay( Tbl_eduCustState.fContactTime) = :MoreDays_A

jishuang

传时间进行过滤参考http://bbs.justep.com/forum.php? ... 48236&pid=165015651

如果查30天前的，应该不是用“=”吧

hxqsys

jishuang 发表于 2013-9-12 09:29
传时间进行过滤参考http://bbs.justep.com/forum.php? ... 48236&pid=165015651

如果查30天前的，应该不是 ...

按照http://bbs.justep.com/forum.php? ... 48236&pid=165015651
的方法问题已解决，可以结贴。