anyone to add this here http://wiki.apache.org/solr/DataImportHandlerFaq
On Thu, Nov 5, 2009 at 8:35 PM, <mpiluson...@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
