Description

Extracts the currency code, such as USD, from an rp_currency value.

Aliases: CURRENCYTYPE

Syntax

CURRENCY_TYPE(expression)

Parameters

Parameter	Description	Data Type	Required
expression	Column or expression to evaluate	Currency V2	Yes

Example

SELECT
    CURRENCY_TYPE(annual_salary_equivalent)
FROM
    rippling.employee.Employee;