How do I add a timezone offset to this query?

Is WP set to that -6 offset you need? In that case try date_i18n() to generate your date instead of date().