Apache Presto - substring(string,start,length)


Query

presto:default> select substring('tutorialspoint',10,5) as substring; 

Result

 substring 
----------- 
   point

Here, the substring of starting index 10 with length 5 is ‘point’.

apache_presto_sql_functions.htm
Advertisements