The javadocs for solr DateField say "A date field shall be of the form 1995-12-31T23:59:59Z The trailing "Z" designates UTC time and is mandatory (See below for an explanation of UTC). Optional fractional seconds are allowed, as long as they do not end in a trailing 0 (but any precision beyond milliseconds will be ignored). All other parts are mandatory."
Perhaps the -1 is due to timezone conversion? http://lucene.apache.org/solr/api/org/apache/solr/schema/DateField.html On Fri, Dec 19, 2008 at 2:58 PM, lunapolar <crismayago...@hotmail.com>wrote: > > Hello!! > > I'm new working with solr. I've got a mysql database with some dates like > that: > > 2009-01-31 > 2009-02-01 > 2008-11-29 > 2008-11-30 > > but when I did a query, *:* for example, I realized that solr had this: > > <date>2009-01-30T23:00:00Z</date> > <date>2009-01-31T23:00:00Z</date> > <date>2008-11-28T23:00:00Z</date> > <date>2008-11-29T23:00:00Z</date> > > A day -!!!!!! How can I fix that, please?? > > > <fieldType name="date" class="solr.DateField" sortMissingLast="true" > omitNorms="true"/> > > > <field column="fechaSesion" name="fechaSesion" /> > > > > -- > View this message in context: > http://www.nabble.com/Problems-with-dates%21%21%21-tp21088241p21088241.html > Sent from the Solr - User mailing list archive at Nabble.com. > > -- Regards, Shalin Shekhar Mangar.
