Actually you can add "timezone=yourtimezone;" at the connection string when using ODBC. Hope this helps!
I'm just writing this out here now I know that.