String

RTRIM

DuckDB

Menghapus karakter dari sisi kanan (akhir) string. Secara default menghapus whitespace, bisa dikustomisasi untuk karakter tertentu.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

RTRIM(string [, characters])

Parameter

stringVARCHARwajib

String yang akan di-trim dari kanan

charactersVARCHARopsional

Karakter-karakter yang akan dihapus. Default: whitespace

Contoh Penggunaan

Menghapus Spasi di Akhir

SQL

1 SELECT
2   '>' || RTRIM('Hello World   ') || '<' as trimmed;

Menghapus spasi di akhir string.

Hasil

trimmed
>Hello World<

Menghapus Trailing Zeros

SQL

1 SELECT
2   price_string,
3   RTRIM(price_string, '0') as clean_price
4 FROM (
5   SELECT '100.5000' as price_string UNION ALL
6   SELECT '250.1200' UNION ALL
7   SELECT '99.0000'
8 );

Menghapus nol di belakang angka desimal.

Hasil

price_string	clean_price
100.5000	100.5
250.1200	250.12
99.0000	99.

Membersihkan Suffix Punctuation

SQL

1 SELECT
2   raw_text,
3   RTRIM(raw_text, '.,;!?') as clean_text
4 FROM (
5   SELECT 'Hello World!!!' as raw_text UNION ALL
6   SELECT 'How are you???' UNION ALL
7   SELECT 'Nice to meet you...'
8 );

Menghapus tanda baca berlebih di akhir kalimat.

Hasil

raw_text	clean_text
Hello World!!!	Hello World
How are you???	How are you
Nice to meet you...	Nice to meet you

Fungsi Terkait

TRIMLTRIM

Kembali ke DuckDB Functions

1	SELECT
2	price_string,
3	RTRIM(price_string, '0') as clean_price
4	FROM (
5	SELECT '100.5000' as price_string UNION ALL
6	SELECT '250.1200' UNION ALL
7	SELECT '99.0000'
8	);

1	SELECT
2	raw_text,
3	RTRIM(raw_text, '.,;!?') as clean_text
4	FROM (
5	SELECT 'Hello World!!!' as raw_text UNION ALL
6	SELECT 'How are you???' UNION ALL
7	SELECT 'Nice to meet you...'
8	);