mssql: no TRUNC/TRUNCATE function at all -- uses the (real, if
obscure) third argument of T-SQL's ROUND(value, decimals, function),
where a non-zero third argument truncates instead of rounding:
ROUND(value, decimals, 1).
sqlite: the math-functions extension's trunc(X) only accepts a single
argument (no decimals support) -- when decimals is supplied, a
TRUNC(value * 10^n) / 10^n fallback is used.
clickhouse: trunc(value, decimals) (lower-case, 2-arg form supported).
Truncate a value toward zero (no rounding), optionally to
decimalsdecimal places.TRUNCATE(value, decimals)(function name isTRUNCATE, notTRUNC; decimals defaults to 0 when omitted).TRUNC(value, decimals).TRUNC/TRUNCATEfunction at all -- uses the (real, if obscure) third argument of T-SQL'sROUND(value, decimals, function), where a non-zero third argument truncates instead of rounding:ROUND(value, decimals, 1).trunc(X)only accepts a single argument (no decimals support) -- whendecimalsis supplied, aTRUNC(value * 10^n) / 10^nfallback is used.trunc(value, decimals)(lower-case, 2-arg form supported).