lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From William Bell <billnb...@gmail.com>
Subject Re: indexing mysql dateTime/timestamp into solr date field
Date Wed, 02 Mar 2011 03:40:41 GMT
<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 <ysxsusan@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.
>

Mime
View raw message