RIGHT
Returns the specified characters from the right side of a string.
Behavior Type
Syntax
RIGHT ( string‑expr, length )
Parameters
string‑expr |
The string expression to return. |
length |
An integer value that specifies how many characters to return. |
Examples
The following query returns the last three characters of the string 'vertica':
=> SELECT RIGHT('vertica', 3); RIGHT ------- ica (1 row)
The following query queries date column date_ordered
from table store.store_orders_fact
. It coerces the dates to strings and extracts the last five characters from each string. It then returns all distinct strings:
SELECT DISTINCT( RIGHT(date_ordered::varchar, 5)) MonthDays FROM store.store_orders_fact ORDER BY MonthDays; MonthDays ----------- 01-01 01-02 01-03 01-04 01-05 01-06 01-07 01-08 01-09 01-10 02-01 02-02 02-03 ... 11-08 11-09 11-10 12-01 12-02 12-03 12-04 12-05 12-06 12-07 12-08 12-09 12-10 (120 rows)