plsql left() function
snippet in sql

plsql left() function

user5048

SUBSTR( "20190601", 0, 6 )

plsql substr

user5459

SUBSTR( string, start_position [, length ] )