TimePeriodPreciseOp

export const timePeriodPreciseOp: OperatorData = {
  id: TIMEPERIODPRECISE,
  cptn: "between",
  caseIns: true,
  isRange: true,
  fmt: "{expr1} [[between]] {expr2} and {expr3}",
  pcnt: 3,
  editor: "_DPTE",
  operands: [
    {
      dtype: 0,
      kind: 0,
      val: "${HourStart}"
    },
    {
      dtype: 0,
      kind: 0,
      val: "${Now}"
    }
  ]
};


/* some other code */

export const getAttrOperators = (
  sqlType: string,
  nullable: number
): string[] => {
  let operators: string[] = [];

  switch (sqlType.toLowerCase()) {
    // Other data type handled ..

    case "time":
      operators = [
        TIMEEQUALPRECISE,
        TIMENOTEQUALPRECISE,
        TIMEBEFOREPRECISE,
        TIMEAFTERPRECISE,
        TIMEPERIODPRECISE
      ];
      break;
  }

  if (nullable === 1) {
    operators = operators.concat(ISNULL, ISNOTNULL);
  }

  return operators;
};