Solr indexes all times as UTC (that's what the "Z' is all about). You ought
to be able to get your SQL to return UTC time rather than local, and that
should fix things up for you.
Best
Erick
On Tue, Jun 19, 2012 at 6:24 AM, alex.wang <wang_...@sohu.com> wrote:
> hi all:
> when i import the data from db to solr. and solr changed the value with
> timezone.
> eg, the original value is 16/02/2012 12:05:16 , changed to 1/02/2012
> 04:05:06
> . and i add the 8 hours in my sql . it's be correct.
> but when i use delta-import mode to add index. it's not working.
> the sql in config as follow:
> <entity name="sharing" pk="id"
> query="select t.id, t.content , t.money , t.tradeTgtId , t0.name
> , DATE_ADD(t.time,INTERVAL 8 HOUR) as time from sharing t LEFT JOIN tradetgt
> t0 on t.tradeTgtId = t0.id "
> deltaImportQuery="select t.id, t.content , t.money ,
> t.tradeTgtId , t0.name , t.time from sharing t LEFT JOIN tradetgt t0 on
> t.tradeTgtId = t0.id where t.id = '${dataimporter.delta.id}'" >
> deltaQuery="select id from sharing where DATE_ADD(time,INTERVAL
> 8 HOUR) > '${dataimporter.last_index_time}'" >
> <field column="id" name="id"/>
> <field column="content" name="sharing_content"/>
> <field column="time" name="sharing_time"/>
> <field column="money"
> name="sharing_money"/>
> <field column="name"
> name="trade_name"/>
> </entity>
>
> and no log error.
> i don't know why?
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/question-about-DIH-tp3990261.html
> Sent from the Solr - User mailing list archive at Nabble.com.
