I guess, you will need to modify your extraction select in order to fix it, using some date functions provided by the database manufacturer. For example, in some projects when using oracle as a data source i've been using the next recipe to modify the oracle TIMESTAMP(6) datatype to fit the solr date:
select... ... TO_CHAR (myTable.timestamp_colum, 'YYYY-MM-DD') ||'T'|| TO_CHAR (myTable.timestamp_colum,'HH24:MI:SS')||'Z' ... from myTable... .... Hope it helps On Fri, May 9, 2014 at 10:38 AM, hakanbillur <a.hakanbil...@hotmail.com>wrote: > <http://lucene.472066.n3.nabble.com/file/n4135079/Capture2.png> > <http://lucene.472066.n3.nabble.com/file/n4135079/Capture.png> > > Hi, > > I have a problem about indexing UTC date format to solr from DB. For > example, in DB, date:"2014-05-01 23:59:00" and same date: "date": > "2014-05-01T20:59:00Z" in solr. > There are time diifference -3 hours! (For Turkey). > > you can see about two captures on the right side. > > i hope, someone can help me. > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Indexing-DateField-timezone-problem-tp4135079.html > Sent from the Solr - User mailing list archive at Nabble.com. >
