solr daterange data not match

2018-06-06 Thread Albert Lee
Hi all, I defined a date range type in solr schema. And then I try to write date to solr in my Java code, like this, SimpleDateFormat sdf = new SimpleDateFormat(“-MM-dd HH:mm:ss”); doc.addField(“date”, sdf.parse(“1990-01-01 15:36:42”)); while the data in solr is: "date": "1900-01-01T08:00:00

RE: solr query

2018-03-15 Thread Albert Lee
e workarounds that got mentioned. -Stefan On Mar 15, 2018 4:08 AM, "Albert Lee" wrote: > Hi Emir, > > If using OR-ed conditions for different years then the query will be very > long if I got 100 years and I think this is not practical. > You have any other idea? > &g

RE: solr query

2018-03-14 Thread Albert Lee
ary, from 31*8640+1 to … is February and so on. > >> > >> If you go this path, I would suggest custom function that will convert > >> date to month/year. > >> > >> HTH, > >> Emir > >> -- > >> Monitoring - Log Management - Alerting - Anomaly Dete

RE: solr query

2018-03-14 Thread Albert Lee
http://sematext.com/ > On 14 Mar 2018, at 10:31, Albert Lee wrote: > > NOW/MONTH and NOW/YEAR to get the start of month/year, but how can I get > current month of regardless year. Like the use case, people who’s birthdate > is this month? > > Regard, > Albert > &g

RE: solr query

2018-03-14 Thread Albert Lee
tml#WorkingwithDates-DateMathSyntax> HTH, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > On 14 Mar 2018, at 04:21, Albert Lee wrote: > > Dear Solr, > I want to whether solr support quer

solr query

2018-03-13 Thread Albert Lee
Dear Solr, I want to whether solr support query by this year or this month? If can, how to do that. Thanks. Regards, Albert