Re: [Geoserver-users] Problem with timestamps and Oracle datastore

2016-03-19 Thread DGIS Devels
We had not thought it was a problem related to the time change. We haveconsidered it and and that Geoserver returns results in GMT, and no problem with the hour. However, we still find answers to the date indicated with a day less than stored in BD. Thank you very much for your response.

Re: [Geoserver-users] Problem with timestamps and Oracle datastore

2016-03-19 Thread Andrea Aime
On Thu, Mar 17, 2016 at 12:09 PM, DGIS Devels wrote: > We had not thought it was a problem related to the time change. We > haveconsidered it and and that Geoserver returns results in GMT, and no > problem with the hour. > Dates are also converted to GMT, there is an

Re: [Geoserver-users] Problem with timestamps and Oracle datastore

2016-03-19 Thread Ian Turton
The day change occurs because your time stamp was truncated to a date at some point and then moved back by an hour (or two) which moves it into the previous day and then it got truncated again. Ian On 17 March 2016 at 11:09, DGIS Devels wrote: > We had not thought

Re: [Geoserver-users] Problem with timestamps and Oracle datastore

2016-03-18 Thread DGIS Devels
All right! We will consider it when showing the return date field. Thanks to all, again 2016-03-17 12:25 GMT+01:00 Andrea Aime : > On Thu, Mar 17, 2016 at 12:09 PM, DGIS Devels > wrote: > >> We had not thought it was a problem related to

Re: [Geoserver-users] Problem with timestamps and Oracle datastore

2016-03-16 Thread Ian Turton
The quick answer to why there is a 2 hour difference is daylight savings (or summer) time. You are actually in GMT+2 in June. The simple answer is for your client to convert all your timestamps to GMT before any interaction with the data base if that is what you have the database set to. Ian On

Re: [Geoserver-users] Problem with timestamps and Oracle datastore

2016-03-16 Thread DGIS Devels
Hi, any help on this, please? We fail to understand why the date is sent with a day less than that stored in BD and time to two hours before. Thanks 2016-03-11 12:21 GMT+01:00 DGIS Devels : > Hi all, > > we are having problems retrieving data using WFS from a oracle

[Geoserver-users] Problem with timestamps and Oracle datastore

2016-03-11 Thread DGIS Devels
Hi all, we are having problems retrieving data using WFS from a oracle datastore, specifically related to dates and timestamps. We have read other posts in which other people had similar problems, but not found response. Our WFS filters are similar to: http://www.opengis.net/ogc;>

[Geoserver-users] Problem with timestamps and Oracle datastore

2016-03-11 Thread DGIS Devels
Hi all, we are having problems retrieving data using WFS from a oracle datastore, specifically related to dates and timestamps. We have read other posts in which other people had similar problems, but not found response. Our WFS filters are similar to: http://www.opengis.net/ogc;>