<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.

Reply via email to