Re: having problem about Solr Date Field.

: So, regarding DST, do you put everything in GMT, and make adjustments : for in the 'seach for/between' data/time values before the query for : both DST and TZ? The client adding docs is hte only one that knows what TZ it's in when it formats the docs to add them, and the client issuing the q

Re: having problem about Solr Date Field.

t; Subject: Re: having problem about Solr Date Field. > To: solr-user@lucene.apache.org > Date: Monday, October 11, 2010, 3:23 PM > > : Of course if your index is for users in one time zone > only, you may > : insert the local time to Solr, and everything will work > well. Ho

Re: having problem about Solr Date Field.

: Of course if your index is for users in one time zone only, you may : insert the local time to Solr, and everything will work well. However, This is a bad assumption to make -- it will screw you up if your "one time zone" has anything like "Daylight Saving Time" (Because UTC Does not) -Hos

Re: having problem about Solr Date Field.

nt > Subject: Re: having problem about Solr Date Field. > To: solr-user@lucene.apache.org > Date: Friday, October 8, 2010, 3:46 AM > Correct. You get back what you push > in. > > Of course if your index is for users in one time zone only, > you may insert the local time to Solr,

Re: having problem about Solr Date Field.

gt; > > --- On Thu, 10/7/10, Lance Norskog wrote: > >> From: Lance Norskog >> Subject: Re: having problem about Solr Date Field. >> To: solr-user@lucene.apache.org >> Date: Thursday, October 7, 2010, 5:06 PM >> Solr stores dates in UTC. There is no >

Re: having problem about Solr Date Field.

a to learn from others’ mistakes, so you do not have to make them yourself. from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036' EARTH has a Right To Life, otherwise we all die. --- On Thu, 10/7/10, Lance Norskog wrote: > From: Lance Norskog > Subject:

Re: having problem about Solr Date Field.

Solr stores dates in UTC. There is no timezone conversion or other date-format processing in Solr. The admin screen only shows in UTC. -- I want to get local time(JST) on Solr Admin. On Wed, Oct 6, 2010 at 9:14 AM, Gora Mohanty wrote: > On Wed, Oct 6, 2010 at 9:17 PM, Kouta Osabe wrote: >>

Re: having problem about Solr Date Field.

On Wed, Oct 6, 2010 at 9:17 PM, Kouta Osabe wrote: > Hi, Gora > > Thanks for your advice. > > and then I try to write these codes following your advice. > > Case1 > "pub_date" column(MySQL) is 2010-09-27 00:00:00. > > I wrote like below. > > SolrJDto info = new SolrJDto(); > TimeZone tz2 = TimeZon

Re: having problem about Solr Date Field.

Hi, Gora Thanks for your advice. and then I try to write these codes following your advice. Case1 "pub_date" column(MySQL) is 2010-09-27 00:00:00. I wrote like below. SolrJDto info = new SolrJDto(); TimeZone tz2 = TimeZone.getTimeZone("UTC+9"); Calendar cal = Calendar.getInstance(tz2); // publ

Re: having problem about Solr Date Field.

> I expected "2010-10-05 00:00:00" to display by Solr Admin > but > "2010-10-04T15:00:00Z" displayed on Solr Admin. > > is this timezone problem?(I live in Tokyo Japan). Probably. Solr stores/converts dates in/to UTC timezone.

Re: having problem about Solr Date Field.

On Mon, Oct 4, 2010 at 10:24 PM, Kouta Osabe wrote: > Hi,All > > I have a problem about Solr Date Field. [...] > the value of pub_date column comes from MySQL and actually value is > "2010-10-05 00:00:00". > > I regist "foo" bean to Solr through SolrJ like "new > CommonsHttpSolrServer().addBean(f

having problem about Solr Date Field.

Hi,All I have a problem about Solr Date Field. The problem is like below. SolrBean foo = new Bean(); // The type of pubDate property is "java.util.Date" and rs means "java.sql.ResultSet" so rs.getDate("pub_date") retuns java.sql.Date Object. bean.pubDate = rs.getDate("pub_date"); the value of p