HANA中的BETWEEN运算子 [英] BETWEEN operator in HANA
本文介绍了HANA中的BETWEEN运算子的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我必须编写一个条件,其中必须检查其他两个日期值之间的"DATE",如示例所示:
I have to write a condition where I have to check a "DATE" lie beween two other date values as shown in the example:
var_out= CE_PROJECTION(:table1,["col1","col2","col3","col4"], ' " col2" BETWEEN "col3" AND "col4" ' );
但这会引发我一个错误SQL: transaction rolled back by an internal error: Syntax Error in filter expression
But this throws me an error SQL: transaction rolled back by an internal error: Syntax Error in filter expression
有人可以为此建议正确的语法吗?
Could anyone suggest the right syntax for this?
谢谢
推荐答案
CE_PROJECTION的过滤器表达式中不支持两者之间.
Between is not supported in the filter expression of CE_PROJECTION.
您可以尝试
var_out= CE_PROJECTION(:table1,["col1","col2","col3","col4"], ' "col2" >= "col3" AND "col2" <= "col4" ' );
希望有帮助.
这篇关于HANA中的BETWEEN运算子的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文