ST_DateTimeGrouping (Date Time Grouping)

Specifies how to group dateTime values.

This simple type's contents are a restriction of the XML Schema string datatype.

The following are possible enumeration values for this type:

Enumeration Value	Description
day (Day)	Group by day
hour (Group by Hour)	Group by hour
minute (Group by Minute)	Group by minute
month (Month)	Group by month
second (Second)	Group by second
year (Group by Year)	Group by year

 

Referenced By

dateGroupItem@dateTimeGrouping (§3.3.2.4)

The following XML Schema fragment defines the contents of this simple type:

<simpleType name="ST_DateTimeGrouping">

   <restriction base="xsd:string">

   <enumeration value="year"/>

   <enumeration value="month"/>

   <enumeration value="day"/>

   <enumeration value="hour"/>

   <enumeration value="minute"/>

   <enumeration value="second"/>

   </restriction>

</simpleType>