Rtrim

String Function

Description

Removes trailing characters, including whitespace, from a string

Click here to navigate to the PostgreSQL docs page for this syntax.

The function Rtrim() is supported on Snowflake.

Grammar Syntax

RTRIM(<expr> , <characters>)

Sample Source Patterns

PostgreSQL

Code

SELECT RTRIM('$125.00', '0.');

Result

$125

Snowflake

Code

SELECT RTRIM('$125.00', '0.');

Result

$125