I found a way to store MySQL DateTime as a string in Solr Here is the way
in data-config.xml in the SQL query we could convert the date directly to char CAST(l.creation_date as char) as creation_date, CAST(l.modification_date as char) as modification_date, in schema.xml <field name="creation_date" type="string" indexed="true" stored="true" multiValued="false" default="" /> <field name="modification_date" type="string" indexed="true" stored="true" multiValued="false" default="" /> Output would be <str name="creation_date">2013-11-13 10:26:32</str> <str name="modification_date">2013-11-13 10:26:32</str> This is exactly what I was looking for. If you guys have any other wise please free to share. :-). Happy Solr!!! -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4109720.html Sent from the Solr - User mailing list archive at Nabble.com.
