<field column="date" dateTimeFormat="yyyy-MM-dd'T'hh:mm:ss" />
Did you convert the date to standard GMT format as above in DIH? Also add transformer="DateFormatTransformer,..." http://lucene.apache.org/solr/api/org/apache/solr/schema/DateField.html On Tue, Mar 1, 2011 at 7:54 PM, cyang2010 <ysxsu...@hotmail.com> wrote: > Yes, I am pretty sure every row has a modified field. I did my testing > before posting question. > > I tried with adding DateFormatTransformer, still not help. > > > <entity name="title" > query="select ID, title_full as TITLE_NAME, YEAR, > COUNTRY_OF_ORIGIN, modified as RELEASE_DATE from title limit 10" > > > transformer="RegexTransformer,DateFormatTransformer,TemplateTransformer"> > > <field column="ID" name="id" /> > > <field column="TITLE_NAME" name="title_name" /> > > <field column="YEAR" name="year" /> > <field column="COUNTRY_OF_ORIGIN" name="country" /> > > <field column="RELEASE_DATE" name="release_date" > dateTimeFormat="yyyy-MM-dd"/> > > I assume it is ok to just get the date part of the information out of a > datetime field? > > Any thought on this? > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/indexing-mysql-dateTime-timestamp-into-solr-date-field-tp2608327p2608452.html > Sent from the Solr - User mailing list archive at Nabble.com. >
