2014-03-26 UTC
# 
pauloppenheim KartikPrabhu: try SELECT `blogengine_note`.`id`, `blogengine_note`.`slug`, `blogengine_note`.`pub_date`, `blogengine_note`.`_in_reply_to`, `blogengine_note`.`_content`, EXTRACT(MONTH FROM CONVERT_TZ(`blogengine_note`.`pub_date`, 'UTC', America/Los_Angeles)) FROM `blogengine_note` ORDER BY `blogengine_note`.`pub_date` DESC