It turn out you don't need to use dateFormatTransformer at all. The reason why the timestamp mysql column fail to be inserted to solr is because in schema.xml i mistakenly set "index=false, stored=false". Of course that won't make it come to index at all. No wonder schema browser always show no term for that field.
DataImportHanlder just take care of using jdbc to read timestamp/datetime column, and format it into solr format out of box. There is no need to use any transformer on top it. I am guessing that the DateFormatTransformer is only needed for string value (somevalue from a xml source, rather than for database column value) to convert it to solr date type. -- View this message in context: http://lucene.472066.n3.nabble.com/indexing-mysql-dateTime-timestamp-into-solr-date-field-tp2608327p2611865.html Sent from the Solr - User mailing list archive at Nabble.com.
