:) select (now()-interval 10 minute) as tm SELECT now() - toIntervalMinute(10)

Question

:) select (now()-interval 10 minute) as tm SELECT now() - toIntervalMinute(10)

AS tm

Received exception from server:
Code: 62. DB::Exception: Received from clickhouse-........net:9000, 10.253.202.35. DB::Exception: Syntax error: failed at position 24: 10 minute) as tm. Expected one of: Comma, Dot, QuestionMark, AS, BETWEEN, NOT LIKE, LIKE, GLOBAL IN, IN, GLOBAL NOT IN, NOT IN, alias, OR, AND, token, IS.
эммм.... Чет я не пойму, а как надо?

#backend #clickhouse #database #devops #programming #russian

0

27.11.2017