beachmachine / django-jython

Database backends and extensions for Django development on top of Jython.
BSD 3-Clause "New" or "Revised" License
21 stars 7 forks source link

MySQL timezone support #12

Open fed239 opened 8 years ago

fed239 commented 8 years ago

Is it possible to make MySQL backend timezone aware? I set jdbc_connection_url_pattern like the following, but still all datetimes coming from DB backend are naive.

jdbc_connection_url_pattern = 'jdbc:mysql://%(HOST)s:%(PORT)s/%(NAME)s?zeroDateTimeBehavior=convertToNull&useTimezone=true&useLegacyDatetimeCode=true&noTimezoneConversionForTimeType=true&serverTimezone=Europe/Helsinki&noTimezoneConversionForDateType=true&useJDBCCompliantTimezoneShift=true'