Schema documentation for component datetime

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element datetime_type

Namespace

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

Diagram

Properties

content

complex

Used by

Element

predefined_type

Model

kw_date | time_precison_zone | timestamp_precision_zone

Children

kw_date, time_precison_zone, timestamp_precision_zone

Instance

<datetime_type xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_date>{1,1}</kw_date>
  <time_precison_zone>{1,1}</time_precison_zone>
  <timestamp_precision_zone>{1,1}</timestamp_precision_zone>
</datetime_type>

Source

<xs:element name="datetime_type">
  <xs:complexType>
    <xs:choice>
      <xs:element ref="kw_date"/>
      <xs:element name="time_precison_zone">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_time"/>
            <xs:element ref="time_precision" minOccurs="0"/>
            <xs:element ref="with_or_without_time_zone" minOccurs="0"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="timestamp_precision_zone">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_timestamp"/>
            <xs:element ref="time_precision" minOccurs="0"/>
            <xs:element ref="with_or_without_time_zone" minOccurs="0"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element datetime_type / time_precison_zone

Namespace

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

Diagram

Properties

content

complex

Model

kw_time , time_precision{0,1} , with_or_without_time_zone{0,1}

Children

kw_time, time_precision, with_or_without_time_zone

Instance

<time_precison_zone xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_time>{1,1}</kw_time>
  <time_precision>{0,1}</time_precision>
  <with_or_without_time_zone>{0,1}</with_or_without_time_zone>
</time_precison_zone>

Source

<xs:element name="time_precison_zone">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_time"/>
      <xs:element ref="time_precision" minOccurs="0"/>
      <xs:element ref="with_or_without_time_zone" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element datetime_type / timestamp_precision_zone

Namespace

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

Diagram

Properties

content

complex

Model

kw_timestamp , time_precision{0,1} , with_or_without_time_zone{0,1}

Children

kw_timestamp, time_precision, with_or_without_time_zone

Instance

<timestamp_precision_zone xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_timestamp>{1,1}</kw_timestamp>
  <time_precision>{0,1}</time_precision>
  <with_or_without_time_zone>{0,1}</with_or_without_time_zone>
</timestamp_precision_zone>

Source

<xs:element name="timestamp_precision_zone">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_timestamp"/>
      <xs:element ref="time_precision" minOccurs="0"/>
      <xs:element ref="with_or_without_time_zone" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>