Tuesday, May 4, 2010

Find last 12 months a MYSQL way

select monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 1 MONTH)) , year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 1 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 2 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 2 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 3 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 3 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 4 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 4 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 5 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 5 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 6 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 6 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 7 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 7 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 8 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 8 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 9 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 9 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 10 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 10 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 11 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 11 MONTH)),
monthname(date_sub(CURRENT_TIMESTAMP(), INTERVAL 12 MONTH)),year(date_sub(CURRENT_TIMESTAMP(), INTERVAL 12 MONTH))

No comments: