Converting MongoDB DateTime to Local DateTime

Hello All,   I have been using BI Connector + ODBC (It sucks) to connect to my MongoDB and the way dates are stored in my MongoDB instance is +4 or +5 hour offset depending on Daylight savings time...