<entity name="foo" pk="cp_id" transformer="DateFormatTransformer" query="SELECT ..., ...some fields ... cp.start_date_1, cp.start_date_2, cp.end_date_1, cp.end_date_2, .. some other fields .. FROM ..." </entity>
that not works with fields with this value: 0000-00-00 OR/AND 2011-05-18 id tried with: <field column="start_date_1" dateTimeFormat="yyyy-MM-dd'T'hh:mm:ss" /> but solr say always that these fields have a wrong format ! i try my sql-selects before i post it here ,-) ----- ------------------------------- System ---------------------------------------- One Server, 12 GB RAM, 2 Solr Instances, 7 Cores, 1 Core with 31 Million Documents other Cores < 100.000 - Solr1 for Search-Requests - commit every Minute - 5GB Xmx - Solr2 for Update-Request - delta every Minute - 4GB Xmx -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-convert-YYYY-MM-DD-to-YYY-MM-DD-hh-mm-ss-DIH-tp2961481p2961787.html Sent from the Solr - User mailing list archive at Nabble.com.