/** * Converts the interval value into a millisecond representation. * * @param interval Interval * @return a long value that represents millisecond equivalent of the * interval value. */ public static long intervalToMillis( SqlIntervalLiteral.IntervalValue interval) { return intervalToMillis( interval.getIntervalLiteral(), interval.getIntervalQualifier()); }
/** * Converts the interval value into a millisecond representation. * * @param interval Interval * @return a long value that represents millisecond equivalent of the * interval value. */ public static long intervalToMillis( SqlIntervalLiteral.IntervalValue interval) { return intervalToMillis( interval.getIntervalLiteral(), interval.getIntervalQualifier()); }
if (clazz == Long.class) { return clazz.cast(valTime.getSign() * SqlParserUtil.intervalToMillis(valTime)); } else if (clazz == BigDecimal.class) { return clazz.cast(BigDecimal.valueOf(getValueAs(Long.class)));
if (clazz == Long.class) { return clazz.cast(valTime.getSign() * SqlParserUtil.intervalToMillis(valTime)); } else if (clazz == BigDecimal.class) { return clazz.cast(BigDecimal.valueOf(getValueAs(Long.class)));
case INTERVAL_SECOND: long millis = SqlParserUtil.intervalToMillis( literal, type.getIntervalQualifier());
case INTERVAL_SECOND: long millis = SqlParserUtil.intervalToMillis( literal, type.getIntervalQualifier());
final SqlIntervalLiteral.IntervalValue valTime = (SqlIntervalLiteral.IntervalValue) literal.value; return valTime.getSign() * SqlParserUtil.intervalToMillis(valTime);
final SqlIntervalLiteral.IntervalValue valTime = (SqlIntervalLiteral.IntervalValue) literal.value; return valTime.getSign() * SqlParserUtil.intervalToMillis(valTime);
public void checkIntervalConv(String sql, String expected) { SqlValidator validator = getValidator(); final SqlCall n = (SqlCall) parseAndValidate(validator, sql); SqlNode node = null; for (int i = 0; i < n.operandCount(); i++) { node = stripAs(n.operand(i)); if (node instanceof SqlCall) { node = ((SqlCall) node).operand(0); break; } } assertNotNull(node); SqlIntervalLiteral intervalLiteral = (SqlIntervalLiteral) node; SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) intervalLiteral.getValue(); long l = interval.getIntervalQualifier().isYearMonth() ? SqlParserUtil.intervalToMonths(interval) : SqlParserUtil.intervalToMillis(interval); String actual = l + ""; assertEquals(expected, actual); }
public void checkIntervalConv(String sql, String expected) { SqlValidator validator = getValidator(); final SqlCall n = (SqlCall) parseAndValidate(validator, sql); SqlNode node = null; for (int i = 0; i < n.operandCount(); i++) { node = stripAs(n.operand(i)); if (node instanceof SqlCall) { node = ((SqlCall) node).operand(0); break; } } assertNotNull(node); SqlIntervalLiteral intervalLiteral = (SqlIntervalLiteral) node; SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) intervalLiteral.getValue(); long l = interval.getIntervalQualifier().isYearMonth() ? SqlParserUtil.intervalToMonths(interval) : SqlParserUtil.intervalToMillis(interval); String actual = l + ""; assertEquals(expected, actual); }