Dates need to be send in UTC format: YYYY-mm-ddTHH:MM:SSZ
or if you want fractional seconds too: YYYY-mm-ddTHH:MM:SS.NNNZ See https://lucene.apache.org/solr/guide/6_6/working-with-dates.html#WorkingwithDates-DateFormatting There is no automatic conversion for dates On 26 Apr 2019, at 09:50, Neha <neha.gu...@uni-jena.de<mailto:neha.gu...@uni-jena.de>> wrote: Dear SOLR Team, I am using SOLR 6.6.0 version for indexing data stored in the POSTGRESQL database. I am facing an issue and needs your help Below is the snapshot of the table i am trying to index: - <bbhphkoaiajdhlho.png> Steps followed for indexing DATETIMELOG field in above table: - 1) First i created field of type "text" and indexed DATETIMELOG in it. All goes OK and search is possible though it is treated as text which is natural. 2) Change field type to "date" and re-index all database again without restarting the SOLR. All goes OK and search is possible and in SOLR browse interface date is shown in UTC format which is fine <kgkogmljakkaeohf.png> <phhahkgekpbcplho.png> After this i restarted SOLR and tried to re-index again but now i get below warning and SOLR documents are not getting created. org.apache.solr.common.SolrException: Invalid Date String:'2017-12-28 18:50:04.6' I tried searching for this problem on internet but not able to find any solution. I request you to please help me with this (may be some more configuration is required which i am not aware of) and let me know in case any other information is required from side. Thanks and Regards Neha Gupta
