How to convert month between name and digit in MySQL

select month(str_to_date('March', '%M'))
output: 3
select month(str_to_date('Mar', '%b'))
output: 3
monthname(str_to_date('Mar', '%b'))
output: March


Post a Comment

Featured Post

Updated Coupons / promo codes for Google Apps for Work / Business

To redeem: 1. Sign up for Google Apps   2. Go to your billing settings  3. Choose your payment plan  4. Enter your promo code ...