2015-03-31 UTC
# 
KartikPrabhu ben_thatmustbeme: since you asked this is the offending query SELECT DISTINCT CAST(DATE_FORMAT(CONVERT_TZ(`bundle_note`.`pub_date`, 'UTC', 'America/Chicago'), '%Y-%m-01 00:00:00') AS DATETIME) FROM `bundle_note` WHERE `bundle_note`.`pub_date` <= '2015-03-31 01:44:30' ORDER BY 1 DESC LIMIT 1