[mapguide][MG230][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/MG230

Type
 Defect

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

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

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

- Platform set to new value
  All
- Defect Severity set to new value
  High
- Artifact Status set to new value
  New
- Operating system set to new value
  All
- Artifact created
- Version set to new value
  1.0.0
- Subcomponent set to new value
  Feature Service
- Component set to new value
  Server
- Priority set to new value
  P2
- 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.
- 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.
- Summary set to new value
  Support all forms of FDO DateTime data

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