Requested dates in feature type SiteSinglePhenomTimeSeries get timezone
information
-----------------------------------------------------------------------------------
Key: GEOS-1919
URL: http://jira.codehaus.org/browse/GEOS-1919
Project: GeoServer
Issue Type: Bug
Components: Community schema
Environment: PostgreSQL database, BOM data
Reporter: Volker Mische
Assignee: Andrea Aime
The community schema has feature types that include a date. That date shouldn't
contain any time information.
The SiteSinglePhenomTimeSeries feature type uses a view named "all_data" for
its mapping. It is a union of the daily_rainfall, monthy_rainfall and
yearly_rainfall tables. daily_rainfall, monthy_rainfall uses the type "date"
for storing the date information; yearly_rainfall uses timestamptz (I can't see
any reason why it shouldn't use "date" too).
It seems that if one type is of timestamptz the others get converted to that
too. The result of the view has a date information of type timestamptz.
Further information and examples can be found at
https://extranet.lisasoft.com/wiki/index.php/Software_Test_Results
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
