[Geoserver-devel] [jira] Created: (GEOS-1919) Requested dates in feature type SiteSinglePhenomTimeSeries get timezone information

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