In SQLite, substring()
is an alias for substr()
.
It returns a substring from a string, based on a given starting location within the string. Two arguments are required, and a third optional argument is accepted.
The substring()
naming was introduced in SQLite 3.34.0, which was released on 1st December 2020. The reason that the substring()
syntax was introduced was for compatibility with SQL Server.