Yes, I use timestamp with my postgres fields. Time didn't work for me there, either. But that seemed to be a limitation of postgres more than anything else.
http://www.postgresql.org/docs/8.2/static/datatype-datetime.html From: Arne Kepp [mailto:[email protected]] Sent: Wednesday, March 02, 2011 9:32 AM To: Gundel, Aaron Cc: [email protected] Subject: Re: [Geoserver-users] oracle date time (Tried to respond to this one earlier, so this may be a duplicate posting.) Don't know about Oracle, but I had a lot of trouble with WFS-T and date fields in Postgis. I ended up switching the column to timestamp, and all my problems disappeared. -Arne On 3/2/11 12:38 AM, Gundel, Aaron 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] https://lists.sourceforge.net/lists/listinfo/geoserver-users
