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().

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)