Hmm... perhaps the Oracle datastore could be updated to include: ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
That may fix things... I don't have time to try it myself right now though. -Miles Gundel, Aaron wrote: > Thanks Jukka, > > That's what I've been doing. I was just wondering if there was a more > eloquent way of getting the Oracle dates to show the time also > (through geoserver). > > Aaron > > -----Original Message----- > From: Rahkonen Jukka [mailto:[email protected]] > Sent: Wednesday, March 02, 2011 2:22 PM > To: Gundel, Aaron; Justin Deoliveira > Cc: [email protected] > Subject: Re: [Geoserver-users] oracle date time > > Hi, > > Oracle is a bit peculiar with dates. In theory it does support > timestamps (see for example > http://www.oradev.com/oracle_timestamp.jsp). However, if you just want > to show dates and times, create a view and convert Oracle dates into > strings formatted as you like. It gets more complicated if you need to > insert/update Oracle dates with WFS-T. We desided to use strings also > in that case and our database gurus made something on the database > side to do the conversion on-the-fly. > > -Jukka Rahkonen- > > > -----Alkuperäinen viesti----- > Lähettäjä: Gundel, Aaron [mailto:[email protected]] > Lähetetty: ke 2.3.2011 19:52 > Vastaanottaja: Justin Deoliveira > Kopio: [email protected] > Aihe: Re: [Geoserver-users] oracle date time > > In the database, it's a DATE field. In Geoserver, it comes across as > a Date. As Arne mentioned in the other post, using Timestamp in > postgres seems to resolve this (as the GeoServer type changes to > TimeStamp). It doesn't in Oracle (timestamps don't even show up in > the attribute list). If there was some means to make the Oracle Date > come across as a Timestamp (since it also contains a time), I'm > wondering if that would resolve the issue. > > Aaron > > From: Justin Deoliveira [mailto:[email protected]] > Sent: Wednesday, March 02, 2011 7:44 AM > To: Gundel, Aaron > Cc: [email protected] > Subject: Re: [Geoserver-users] oracle date time > > What is the type of the field at the database level? And if you do a > wfs describeFeatureType what does the xml schema type come across as. > > One thing that might help is to customize the feature type schema as > described here: > > http://docs.geoserver.org/stable/en/user/services/wfs/schemamapping.ht ml > > In which you can change the field type explicitly to xs:dateTime. > > -Justin > On Tue, Mar 1, 2011 at 4:38 PM, Gundel, Aaron > <[email protected]<mailto:[email protected]>> wrote: > Good day fellow GeoServer users, > > I seem to have come across some type of issue with dates and times in > GeoServer. I'm using the oracle datastore to connect to a table that > has a date field in it. The times in this field are not coming across > properly (they're all midnight - 12:00 - so I assume that means > they're being truncated or somesuch along the way) when I do a wms > getfeatureinfo call (or wfs getfeature call, for that matter). Is > there a workaround to get the time through to my application? I'm > turning the field into a string right now to get it across, but if > there's a better way to do so, I'd certainly be interested. > > Many thanks! > > Aaron > > ---------------------------------------------------------------------- > -------- Free Software Download: Index, Search & Analyze Logs and other > IT data in Real-Time with Splunk. Collect, index and harness all the > fast moving IT data generated by your applications, servers and devices > whether physical, virtual or in the cloud. Deliver compliance at lower > cost and gain new business insights. http://p.sf.net/sfu/splunk- dev2dev > _______________________________________________ Geoserver-users mailing > list [email protected]<mailto:Geoserver- > [email protected]> > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > Regards, Miles ___________________________________________________________________________ Australian Antarctic Division - Commonwealth of Australia IMPORTANT: This transmission is intended for the addressee only. If you are not the intended recipient, you are notified that use or dissemination of this communication is strictly prohibited by Commonwealth law. If you have received this transmission in error, please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and DELETE the message. Visit our web site at http://www.antarctica.gov.au/ ___________________________________________________________________________ ------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
