Though one can insert an UpdateRequestProcessor to convert any date format.
See solrconfig.xml for how it is setup (as part of 'schemaless' parsing).
Regards,
Alex
On Fri, Apr 26, 2019, 3:57 AM Nicolas Franck, <nicolas.fra...@ugent.be>
wrote:
> 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
>
>
