title: Solr Indexing My SQL Timestamp or Date Time field
body: <p>To index Date in Solr, Date should be in ISO format.
  Can we index MySQL Timestamp or Date Time feild with out modifying SQL  Select Statement ?</p>
  
  <p>I have used </p>
  
  <pre><code> &lt;fieldType name="tdate" class="solr.TrieDateField" omitNorms="true" precisionStep="6"     positionIncrementGap="0"/&gt;
  
   &lt;field name="CreatedDate" type="tdate" indexed="true" stored="true" /&gt;
  
   CreatedDate is of Type Date Time in MySQL
  </code></pre>
  
  <p>I am getting following exception </p>
  
  <pre><code> 11:23:39,117 WARN  [org.apache.solr.handler.dataimport.DateFormatTransformer] (Thread-  72) Could not parse a Date field : java.text.ParseException: Unparseable date: "2013-04-14 11:22:48.0"
  </code></pre>
  
  <p>Any help in fixing this Issue is really appreciated </p>