DATE_ADD(CONVERT_TZ(DATE_FORMAT(CONVERT_TZ(DATE_SUB(created_at, INTERVAL 0 HOUR), '+00:00', 'Etc/UTC'), '%Y-%m-%d %H:00:00'), 'Etc/UTC', '+00:00'), INTERVAL 0 HOUR) AS date_add_convert_tz_date_format_convert_tz_date_sub_created_at_interval_0_hour_00_00_etc_utc_y_m_d_h_00_00_etc_utc_00_00_interval_0_hour