Hi Shekhar, Thanks for replying :-). Yes your answer is justifiable. DateFormatTransformer was a good consideration. However it doesn't out the format I expected. Rather it outputs in the following manner
<str name="publish_date">Tue Jun 05 00:00:00 MYT 2012</str> Here is DIH configuration <field name="publish_date" column="publish_date" xpath="/RDF/item/date" dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss" locale="en"/> And also I tried this way <field name="publish_date" column="publish_date" xpath="/RDF/item/date" dateTimeFormat="yyyy-MM-dd HH:mm:ss" locale="en"/>*-- without having 'T'* Output is the same :-) I expected date format to be *yyyy-MM-dd HH:mm:ss* -- View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4106849.html Sent from the Solr - User mailing list archive at Nabble.com.