在DolphinDB database的GUI中,执行ListedDate between (date_begin+":"+ date_end),提示“The second argument of 'between' must be a pair”,如下图所示:
请问一下:这个between 后面如果是带变量,是不是只能改写为 a<x1 and a>x2 这种模式?
可以用下面代码所示方式:
t=table([2,3,NULL,1] as v,[2010.01.01,2010.01.01,2010.01.03,2010.01.02] as dates) d1=2010.01.01 d2=2010.01.02 select * from t where dates between d1:d2
2.1m questions
2.1m answers
63 comments
56.7k users