[string] How to concatenate strings with padding in sqlite

SELECT 
  (
    col1 || '-' || SUBSTR('00' || col2, -2, 2) | '-' || SUBSTR('0000' || col3, -4, 4)
  ) AS my_column 
FROM
  mytable;

Examples related to string

• How to split a string in two and store it in a field • String method cannot be found in a main class method • Kotlin - How to correctly concatenate a String • Replacing a character from a certain index • Remove quotes from String in Python • Detect whether a Python string is a number or a letter • How does String substring work in Swift • How does String.Index work in Swift • swift 3.0 Data to String? • How to parse JSON string in Typescript

Examples related to sqlite

• getting " (1) no such column: _id10 " error • Laravel: PDOException: could not find driver • auto create database in Entity Framework Core • How to open .SQLite files • Accessing an SQLite Database in Swift • When does SQLiteOpenHelper onCreate() / onUpgrade() run? • Attempt to write a readonly database - Django w/ SELinux error • Android sqlite how to check if a record exists • How can I add the sqlite3 module to Python? • "Insert if not exists" statement in SQLite

Examples related to string-concatenation

• How do I concatenate strings? • How do I concatenate strings in Swift? • How to set the id attribute of a HTML element dynamically with angularjs (1.x)? • C++ String Concatenation operator<< • how to use concatenate a fixed string and a variable in Python • How do I concatenate strings and variables in PowerShell? • Concatenating variables in Bash • SQL NVARCHAR and VARCHAR Limits • Concatenating string and integer in python • PHP string concatenation

Examples related to leading-zero

• How to remove leading and trailing zeros in a string? Python • How to concatenate strings with padding in sqlite • Javascript add leading zeroes to date