lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Noble Paul നോബിള്‍ नोब्ळ् <noble.p...@corp.aol.com>
Subject Re: DIH timezone offset
Date Fri, 06 Nov 2009 03:27:12 GMT
anyone to add this here
http://wiki.apache.org/solr/DataImportHandlerFaq

On Thu, Nov 5, 2009 at 8:35 PM,  <mpilusonews@comcast.net> wrote:
> """
> DIH relies on the driver to get the date. It does not do any automatic
> conversion. Is it possible for the driver to give the date with the
> right offset?
> """
>
> I have retried a full-import after setting the Java user.timezone property to UTC and
the dates import correctly. I've narrowed down the problem to the way SQL server is returning
dates. Converting it to ISO-8601 format resolves the issue, but I had to append a 'Z' at the
end of the conversion like so: "select convert(varchar(30),datesentutc,126)+'Z' as date from
table".
>
> Hope this is helpful to someone else. Thanks for the help.
>
> Mike
>
>
>
>



-- 
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com

Mime
View raw message