Hi folks, My DB server is on America/Chicago time. Solr (on Docker) is running on UTC. Dates coming from my (MariaDB) data source seem to get translated properly into the Solr index without me doing anything special.
However when doing delta imports using last_index_time ( http://wiki.apache.org/solr/DataImportHandlerDeltaQueryViaFullImport ), I can't seem to get the date, which Solr provides, to be understood by the DB as being UTC (and translated back, accordingly). In other words, the DB thinks the Solr UTC date is local, so it thinks the date is ahead by six hours. '${dataimporter.request.clean}' != 'false' or dt > '${dataimporter.last_index_time}' I came up with this workaround, which seems to work: '${dataimporter.request.clean}' != 'false' /* ${user.timezone} is UTC, and the ${custom.dataimporter.datasource.tz} property is set to America/Chicago */ or dt > CONVERT_TZ('${dataimporter.last_index_time}','${user.timezone}','${ custom.dataimporter.datasource.tz}') However, isn't there a way for this translation to happen more naturally? I thought maybe I could do something like this: <propertyWriter dateFormat="yyyy-MM-dd HH:mm:ssZ" type="SimplePropertiesWriter" /> The above did set the property as expected (with a trailiing `+0000`), but that didn't seem to help the DB understand/translate the date. Thanks, Jamie
