rtrim()

Removes any occurrences of any of the characters from the right side of the string. characters defaults to space.

Reference: DuckDB 2.0.0

Arguments & returns

2 overloads

rtrim(string)

Scalar
Overload link string Returns
#01 VARCHAR VARCHAR

rtrim(string, characters)

Scalar
Overload link stringcharacters Returns
#02 VARCHARVARCHAR VARCHAR
rtrim example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

More examples

rtrim example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

ClickHouse

SELECT LTRIM(s), RTRIM(s), TRIM(s)
In DuckDB
SELECT LTRIM(s), RTRIM(s), TRIM(s)

SQLGlot example ↗

Snowflakebase64_encode()

SELECT BASE64_ENCODE(x, 76)
In DuckDB
SELECT RTRIM(REGEXP_REPLACE(TO_BASE64(x), '(.{76})', '\1' || CHR(10), 'g'), CHR(10))

SQLGlot example ↗