timestamp field

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

timestamp field

Frederico Azeiteiro
Hi,

 

I have on my schema

<field name="timestamp" type="date" indexed="true" stored="true"
default="NOW" />

 

This field is returned as

<date name="timestamp">2010-08-11T10:11:03.354Z</date>

 

For an article added at 2010-08-11T11:11:03.354Z!

 

And the server has the time of 2010-08-11T11:11:03.354Z...

 

This is a w2003 server using solr 1.4.

 

Any guess of what could be wrong here?

 

Thanks,

Frederico

 

 

Reply | Threaded
Open this post in threaded view
|

Re: timestamp field

Jan Høydahl / Cominvent
Hi,

Which time zone are you located in? Do you have DST?

Solr uses UTC internally for dates, which means that "NOW" will be the time in London right now :) Does that appear to be right 4 u?
Also see this thread: http://search-lucene.com/m/hqBed2jhu2e2/

--
Jan Høydahl, search solution architect
Cominvent AS - www.cominvent.com
Training in Europe - www.solrtraining.com

On 11. aug. 2010, at 13.02, Frederico Azeiteiro wrote:

> Hi,
>
>
>
> I have on my schema
>
> <field name="timestamp" type="date" indexed="true" stored="true"
> default="NOW" />
>
>
>
> This field is returned as
>
> <date name="timestamp">2010-08-11T10:11:03.354Z</date>
>
>
>
> For an article added at 2010-08-11T11:11:03.354Z!
>
>
>
> And the server has the time of 2010-08-11T11:11:03.354Z...
>
>
>
> This is a w2003 server using solr 1.4.
>
>
>
> Any guess of what could be wrong here?
>
>
>
> Thanks,
>
> Frederico
>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

RE: timestamp field

Frederico Azeiteiro
Hi Jan,

Dah, I didn't know that :(

I always thought it used the servertime.

Anyway,just out of curiosity, the hour is UTC but NOT the time in London right now.

London is UTC+1 (same as here in Portugal) :).

So, London solr users should have the same "problem".
Well, I must be careful when using this field.

Thanks for your answer,
Frederico

-----Original Message-----
From: Jan Høydahl / Cominvent [mailto:[hidden email]]
Sent: quarta-feira, 11 de Agosto de 2010 12:17
To: [hidden email]
Subject: Re: timestamp field

Hi,

Which time zone are you located in? Do you have DST?

Solr uses UTC internally for dates, which means that "NOW" will be the time in London right now :) Does that appear to be right 4 u?
Also see this thread: http://search-lucene.com/m/hqBed2jhu2e2/

--
Jan Høydahl, search solution architect
Cominvent AS - www.cominvent.com
Training in Europe - www.solrtraining.com

On 11. aug. 2010, at 13.02, Frederico Azeiteiro wrote:

> Hi,
>
>
>
> I have on my schema
>
> <field name="timestamp" type="date" indexed="true" stored="true"
> default="NOW" />
>
>
>
> This field is returned as
>
> <date name="timestamp">2010-08-11T10:11:03.354Z</date>
>
>
>
> For an article added at 2010-08-11T11:11:03.354Z!
>
>
>
> And the server has the time of 2010-08-11T11:11:03.354Z...
>
>
>
> This is a w2003 server using solr 1.4.
>
>
>
> Any guess of what could be wrong here?
>
>
>
> Thanks,
>
> Frederico
>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: timestamp field

Mark Allan
For what it's worth, London and the rest of the UK is currently  
observing British Summer Time (called Daylight Savings Time in other  
parts of the world) which is why we appear to be UTC+1 between the  
last Sunday in March and the last Sunday in October.

Mark

On 11 Aug 2010, at 12:36 pm, Frederico Azeiteiro wrote:

> Hi Jan,
>
> Dah, I didn't know that :(
>
> I always thought it used the servertime.
>
> Anyway,just out of curiosity, the hour is UTC but NOT the time in  
> London right now.
>
> London is UTC+1 (same as here in Portugal) :).
>
> So, London solr users should have the same "problem".
> Well, I must be careful when using this field.
>
> Thanks for your answer,
> Frederico
>
> -----Original Message-----
> From: Jan Høydahl / Cominvent [mailto:[hidden email]]
> Sent: quarta-feira, 11 de Agosto de 2010 12:17
> To: [hidden email]
> Subject: Re: timestamp field
>
> Hi,
>
> Which time zone are you located in? Do you have DST?
>
> Solr uses UTC internally for dates, which means that "NOW" will be  
> the time in London right now :) Does that appear to be right 4 u?
> Also see this thread: http://search-lucene.com/m/hqBed2jhu2e2/
>
> --
> Jan Høydahl, search solution architect
> Cominvent AS - www.cominvent.com
> Training in Europe - www.solrtraining.com
>
> On 11. aug. 2010, at 13.02, Frederico Azeiteiro wrote:
>
>> Hi,
>>
>>
>>
>> I have on my schema
>>
>> <field name="timestamp" type="date" indexed="true" stored="true"
>> default="NOW" />
>>
>>
>>
>> This field is returned as
>>
>> <date name="timestamp">2010-08-11T10:11:03.354Z</date>
>>
>>
>>
>> For an article added at 2010-08-11T11:11:03.354Z!
>>
>>
>>
>> And the server has the time of 2010-08-11T11:11:03.354Z...
>>
>>
>>
>> This is a w2003 server using solr 1.4.
>>
>>
>>
>> Any guess of what could be wrong here?
>>
>>
>>
>> Thanks,
>>
>> Frederico
>>
>>
>>
>>
>>
>
>


--
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.