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.
