Re: Unparseable date

2008-03-11 Thread Chris Hostetter
: I indexed my docs with field : 1995-12-31T23:59:59.000Z : But when i try to search on that field : order_dt:1995-12-31T23:59:59.000Z , : I get an exception : : Mar 11, 2008 4:13:55 PM org.apache.solr.core.SolrException log : SEVERE: org.apache.solr.core.SolrException: Invalid Date : String:'1995-

Re: Unparseable date

2008-03-11 Thread monkins
I indexed my docs with field : 1995-12-31T23:59:59.000Z But when i try to search on that field : order_dt:1995-12-31T23:59:59.000Z , I get an exception : Mar 11, 2008 4:13:55 PM org.apache.solr.core.SolrException log SEVERE: org.apache.solr.core.SolrException: Invalid Date String:'1995-12-31T23'

Re: Unparseable date

2008-03-05 Thread Daniel Andersson
On Mar 5, 2008, at 11:08 PM, Chris Hostetter wrote: It's ".000" not ":00" ... "2008-02-12T15:02:06.000Z" but like i said: that stack trace is odd, the time doesn't seem like it actually comes from any query params, it looks like it's coming from a previously indexed doc. To work arround th

Re: Unparseable date

2008-03-05 Thread Chris Hostetter
: So if I add :00 to every time, it should be fine? : ie : "2008-02-12T15:02:06:00Z" instead of "2008-02-12T15:02:06Z" It's ".000" not ":00" ... "2008-02-12T15:02:06.000Z" but like i said: that stack trace is odd, the time doesn't seem like it actually comes from any query params, it looks like

Re: Unparseable date

2008-03-05 Thread Daniel Andersson
On Mar 5, 2008, at 10:57 PM, Chris Hostetter wrote: : looking at the current code for DateField.toObject(Fieldable) it seems : inheriently broken, attempting to parse a string right after concating 'Z' : on the end even though the parser expects the Z to already be gone -- i'm : not sure ho

Re: Unparseable date

2008-03-05 Thread Daniel Andersson
On Mar 5, 2008, at 10:46 PM, Chris Hostetter wrote: : According to the schema.xml-file "The format for this date field is of the : form 1995-12-31T23:59:59Z". : : Yet I'm getting the following error on SOME queries: : : Mar 5, 2008 10:32:53 AM org.apache.solr.common.SolrException log : SEVERE:

Re: Unparseable date

2008-03-05 Thread Chris Hostetter
: looking at the current code for DateField.toObject(Fieldable) it seems : inheriently broken, attempting to parse a string right after concating 'Z' : on the end even though the parser expects the Z to already be gone -- i'm : not sure how this could path could *ever* work, regardless of the i

Re: Unparseable date

2008-03-05 Thread Daniel Andersson
It's stored in MySQL (datatype: datetime), then extracted and run through the following code: $date = substr($date, 0, 10) . "T" . substr($date, 11) . "Z"; If there was some odd chars at the end, I would have assumed it would have been included in the error message. SEVERE: java.lang.Runtim

Re: Unparseable date

2008-03-05 Thread Chris Hostetter
: According to the schema.xml-file "The format for this date field is of the : form 1995-12-31T23:59:59Z". : : Yet I'm getting the following error on SOME queries: : : Mar 5, 2008 10:32:53 AM org.apache.solr.common.SolrException log : SEVERE: java.lang.RuntimeException: java.text.ParseException:

Re: Unparseable date

2008-03-05 Thread Ryan Grange
Solr does use 24 hour dates. Are you positive there are no extraneous characters at the end of your date string such as carriage returns, spaces, or tabs? I have the same format in the code I've written and have never had a date parsing problem (yet). Ryan Grange, IT Manager DollarDays Inter