MySQL Format Double Digit Month

Nov 3, 2017
DATE_FORMAT(`created_date`,'%Y-%m')

Use DATE_FORMAT function.

DATE_FORMAT(`created_date`,'%Y-%m')
# Output: 2017-01

The following produce single digit month.

DATE_FORMAT(`created_date`,'%Y-%c')
# Output: 2017-1

CONCAT(YEAR(`created_date`), '-', MONTH(`created_date`))
# Output: 2017-1

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.