2.2.4.15 ST_DatePartLiteral

Target namespace: http://schemas.microsoft.com/office/accessservices/2010/12/application

Referenced by: CT_IndexedDatePartLiteral

A string ([XMLSCHEMA2] section 3.2.1) that specifies a date part literal in an expression.  MUST be one of the following values.

Value	Meaning
YEAR	Specifies the Year date part.
QUARTER	Specifies the Quarter date part.
MONTH	Specifies the Month date part.
DAYOFYEAR	Specifies the DayOfYear date part.
DAY	Specifies the Day date part.
WEEK	Specifies the Week date part.
WEEKDAY	Specifies the Weekday date part.
HOUR	Specifies the Hour date part.
MINUTE	Specifies the Minute date part.
SECOND	Specifies the Second date part.
MILLISECOND	Specifies the Millisecond date part.
ISO_WEEK	Specifies the ISO_Week date part.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this simple type.

 <xsd:simpleType name="ST_DatePartLiteral">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="YEAR" wbld:cname="YEAR"/>
     <xsd:enumeration value="QUARTER" wbld:cname="QUARTER"/>
     <xsd:enumeration value="MONTH" wbld:cname="MONTH"/>
     <xsd:enumeration value="DAYOFYEAR" wbld:cname="DAYOFYEAR"/>
     <xsd:enumeration value="DAY" wbld:cname="DAY"/>
     <xsd:enumeration value="WEEK" wbld:cname="WEEK"/>
     <xsd:enumeration value="WEEKDAY" wbld:cname="WEEKDAY"/>
     <xsd:enumeration value="HOUR" wbld:cname="HOUR"/>
     <xsd:enumeration value="MINUTE" wbld:cname="MINUTE"/>
     <xsd:enumeration value="SECOND" wbld:cname="SECOND"/>
     <xsd:enumeration value="MILLISECOND" wbld:cname="MILLISECOND"/>
     <xsd:enumeration value="ISO_WEEK" wbld:cname="ISO_WEEK"/>
   </xsd:restriction>
 </xsd:simpleType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).