Code: Select all
SELECT MONTH(date_field) FROM tableUpdate: some creative thinking has lead me to the following query. It works. However, I feel like this should be done in a more straightforward way.
Code: Select all
SELECT SUBSTRING(CONCAT('0', MONTH(date_field)) FROM -2 FOR 2) FROM table