Is this necessary to define date_field as <fieldType name="date" class="solr.DateField" > in schema.xml. OR Solr query can work on text field type ?
Akshay-8 wrote: > > You can use DateMath as: > > date_field:[NOW TO NOW+45DAYS] > > On Wed, Jan 7, 2009 at 3:00 PM, prerna07 <pkhandelw...@sapient.com> wrote: > >> >> Hi, >> >> what will be the syntax of this sql query >> SELECT * FROM table WHERE date > SYSDATE and date <SYSDATE+45 >> in solr format ? >> >> I need to fetch records where date is between current date and 45 days >> from >> today. >> >> Thanks, >> Prerna >> -- >> View this message in context: >> http://www.nabble.com/Solr-query-for-date-tp21327696p21327696.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > > > -- > Regards, > Akshay Ukey. > > Enjoy your job, make lots of money, work within the law. Choose any two. > -Author Unknown. > > -- View this message in context: http://www.nabble.com/Solr-query-for-date-tp21327696p21328961.html Sent from the Solr - User mailing list archive at Nabble.com.