did you mean something like this ? DATE_FORMAT(cp.field, '%Y-%m-%di %H:%i:%s') AS field ???
i think i need to add the timestamp to my date fields? or not ? why cannot DIH handle with this ? ----- ------------------------------- 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-tp2961481p2961684.html Sent from the Solr - User mailing list archive at Nabble.com.