Thanks Chris With Regards Aman Tandon
On Fri, Oct 31, 2014 at 5:45 AM, Chris Hostetter <hossman_luc...@fucit.org> wrote: > > : I was just trying to index the fields returned by my msql and i found > this > > If you are importing dates from MySql where you have 0000-00-00T00:00:00Z > as the default value, you should actaully be getting an error lsat time i > checked, but this explains the right way to tell the MySQL JDBC driver not > to give you those values ... > > > https://wiki.apache.org/solr/DataImportHandlerFaq#Invalid_dates_.28e.g._.220000-00-00.22.29_in_my_MySQL_database_cause_my_import_to_abort > > (even if you aren't using DIH to talk to MySQL, the same principle holds > if you are using JDBC, if you are talking to MySQL from some other client > langauge there should be a similar option) > > : Actually i just want to know why it is getting stored as ' > : 0002-11-30T00:00:00Z' on indexing the value 0000-00-00T00:00:00Z. > > like i said: bugs. behavior with "Year 0000" is ndefined in alot of the > underlying date code. as for what that speciic date? ... no idea. > > > -Hoss > http://www.lucidworks.com/ >