X must be a non-empty integral, temporal, or literal vector.

Question

在DolphinDB database中想实现time数据类型分区，代码如下：

times_min=00:00m..23:59m;
times=[];
for(m in times_min) times.append!(time(m));
times.append!(23:59:59.999);
time_range=cutPoints(times, 240);
db=database("", RANGE, time_range);

在GUI中执行时，提示如下错误信息：

time_range = cutPoints(times, 240) => Usage: cutPoints(X, binNum, [freq]). X must be a non-empty integral, temporal, or literal vector.

请问是什么原因？

Answer 1

times的类型不对，可用typestr看一下，改成如下：

times_min=00:00m..23:59m;
 times=array(TIME, 0, 1440);
 for(m in times_min) times.append!(time(m));
 times.append!(23:59:59.999);
 time_range=cutPoints(times, 240);

或者用下面代码：

time_range=time(00:00m+0..239*6).append!(23:59:59.999)