[mapguide][MG231][New] Support all forms of FDO DateTime data

[Ben Trumbore]

You can view the artifact detail at the following URL:

    https://mapguide.osgeo.org/servlets/Scarab/id/MG231

Type
 Defect

Artifact ID
 MG231 (Support all forms of FDO DateTime data)

Reported by
 Ben Trumbore
 bentrumbore (ben.trumbore at autodesk.com)

New artifact details:
---------------------------------------------------------

- Steps to Reproduce set to new value
  Create a feature source with properties containing only Dates or Times.  Query the values of this property for some features, or perform a SelectAggregates query.  All returned Date values will include a 12:00AM timestamp and all Time values will include the date January 1 in the year 1.
- Description set to new value
  FDO recognizes three types of DateTime date: Date only, Time only, and TimeStamp (both date and time present).  Currently, all DateTime feature property values are being returned as TimeStamps.  This adds erroneous time information to Date values and erroneous date information to Time values.

Additionally, when DateTime data is processed during a SelectAggregates query it loses its inherent type (and becomes a TimeStamp).  This is because all DateTimes are converted to integers for sorting and categorizing, then converted back to DateTimes.  The type of the value must be maintained throughout this operation.
- Subcomponent set to new value
  Feature Service
- Version set to new value
  1.0.0
- Artifact created
- Summary set to new value
  Support all forms of FDO DateTime data
- Priority set to new value
  P2
- Operating system set to new value
  All
- Artifact Status set to new value
  New
- Platform set to new value
  All
- Defect Severity set to new value
  High
- Component set to new value
  Server

---------------------------------------------------------
This message was automatically generated by Project Tracker.