SUBSTR
Returns a substring starting from a specified position with an optional length.
Analyze Syntax
func.substr(<str>, <pos>[, <len>])
Analyze Examples
func.substr('StarRocks', 5, 5)
┌─────────┐
│ 'Rocks' │
└─────────┘
SQL Syntax
SUBSTR(<str>, <pos>[, <len>])
SQL Examples
SELECT SUBSTR('StarRocks', 5, 5);
┌───────┐
│ Rocks │
└───────┘