django-jython icon indicating copy to clipboard operation
django-jython copied to clipboard

MySQL timezone support

Open fed239 opened this issue 9 years ago • 0 comments

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'

fed239 avatar May 23 '16 15:05 fed239