TRAILING

MySQL

Example

SELECT TRIM(TRAILING '0' FROM '9000');

Output

'9'

Explanation

The TRIM(TRAILING ... ) function in MySQL removes the trailing character that is specified in the parentheses. In the above example, it removes trailing ‘0’ from ‘9000’. The output becomes ‘9’ after removal of trailing zeros.

PostgreSQL

Example

SELECT TRIM(TRAILING FROM 'PostgreSQL  ');

Output

'PostgreSQL'

Explanation

The TRIM(TRAILING FROM string) function in PostgreSQL is used to remove any trailing whitespaces from the specified string. In the given example, trailing whitespaces from the string ‘PostgreSQL ’ are removed, resulting in ‘PostgreSQL’.

Oracle

Example

SELECT TRIM(TRAILING '0' FROM '7000') AS TrimmedString
FROM dual;

Output

TrimmedString
-------------
700

Explanation

The TRIM() function in this example removes (trims) any trailing ‘0’ characters from the string ‘7000’. The result is ‘700’.