Schema documentation for component single_datetime

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element single_datetime_field

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Used by

Element

interval_qualifier

Model

single_datetime_field_1 | single_datetime_field_2

Children

single_datetime_field_1, single_datetime_field_2

Instance

<single_datetime_field xmlns="http://www.sqlparser.com/xml/ansi2003">
  <single_datetime_field_1>{1,1}</single_datetime_field_1>
  <single_datetime_field_2>{1,1}</single_datetime_field_2>
</single_datetime_field>

Source

<xs:element name="single_datetime_field">
  <xs:complexType>
    <xs:choice>
      <xs:element name="single_datetime_field_1">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="non_second_primary_datetime_field"/>
            <xs:element ref="interval_leading_field_precision" minOccurs="0"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="single_datetime_field_2">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_second"/>
            <xs:element name="interval_leading_field_precision_comma" minOccurs="0">
              <xs:complexType>
                <xs:sequence>
                  <xs:element ref="interval_leading_field_precision"/>
                  <xs:element ref="interval_fractional_seconds_precision" minOccurs="0"/>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element single_datetime_field / single_datetime_field_1

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

non_second_primary_datetime_field , interval_leading_field_precision{0,1}

Children

interval_leading_field_precision, non_second_primary_datetime_field

Instance

<single_datetime_field_1 xmlns="http://www.sqlparser.com/xml/ansi2003">
  <non_second_primary_datetime_field>{1,1}</non_second_primary_datetime_field>
  <interval_leading_field_precision>{0,1}</interval_leading_field_precision>
</single_datetime_field_1>

Source

<xs:element name="single_datetime_field_1">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="non_second_primary_datetime_field"/>
      <xs:element ref="interval_leading_field_precision" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element single_datetime_field / single_datetime_field_2

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

kw_second , interval_leading_field_precision_comma{0,1}

Children

interval_leading_field_precision_comma, kw_second

Instance

<single_datetime_field_2 xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_second>{1,1}</kw_second>
  <interval_leading_field_precision_comma>{0,1}</interval_leading_field_precision_comma>
</single_datetime_field_2>

Source

<xs:element name="single_datetime_field_2">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_second"/>
      <xs:element name="interval_leading_field_precision_comma" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="interval_leading_field_precision"/>
            <xs:element ref="interval_fractional_seconds_precision" minOccurs="0"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element single_datetime_field / single_datetime_field_2 / interval_leading_field_precision_comma

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content	complex
minOccurs	0

Model

interval_leading_field_precision , interval_fractional_seconds_precision{0,1}

Children

interval_fractional_seconds_precision, interval_leading_field_precision

Instance

<interval_leading_field_precision_comma xmlns="http://www.sqlparser.com/xml/ansi2003">
  <interval_leading_field_precision>{1,1}</interval_leading_field_precision>
  <interval_fractional_seconds_precision>{0,1}</interval_fractional_seconds_precision>
</interval_leading_field_precision_comma>

Source

<xs:element name="interval_leading_field_precision_comma" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="interval_leading_field_precision"/>
      <xs:element ref="interval_fractional_seconds_precision" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>