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
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.