How to Get Month Without Leading Zero in SQLite?

You can get month from a SQLite DATE/DATETIME column, for example, by using strftime() function with the %m modifier, like so:

SELECT strftime("%m", "2021-09-12 00:00:00") as month

This would result in:

+-------+
| month |
+-------+
|  09   |
+-------+

However, this would give you the current month with leading zero (for months below 10). To remove the leading zero from the result, you can simply use ltrim(), for example, like so:

SELECT ltrim(strftime("%m", "2021-09-12 00:00:00"), "0") as month

This would result in:

+-------+
| month |
+-------+
|   9   |
+-------+