| HTML Tutorials |
|
|
| XML Tutorials |
|
|
| Browser Scripting |
|
|
| Server Scripting |
|
|
| .NET (dotnet) |
|
|
| Multimedia |
|
|
| Web Building |
|
|
| Java Tutorials |
|
|
| Programming Langauges |
|
|
| Soft Skills |
|
|
|
|
Date and time data types are used for values that contains date and time.
|
|
Date Data Type
|
|
The date data type is used to specify the particular date.
The date is
specified in the following form "YYYY-MM-DD" where:
- YYYY indicat the year
- MM indicate the month
- DD indicate the day
Note: All the components are required!
The following is an example of a date declaration in a
schemas:
|
|
<xs:element name="start" type="xs:date"/>
|
|
|
An element in your document might look as follows:
|
|
<start>2002-09-24</start>
|
|
|
Time Zones
|
|
To specify a time zone, you can either enter a date in UTC time by adding a "Z" behind the date - as follows:
|
|
<start>2002-09-24Z</start>
|
|
|
or you can specify an offset from the UTC time by adding a positive or negative time behind the date - as follows:
|
<start>2002-09-24-06:00</start>
or
<start>2002-09-24+06:00</start>
|
|
|
Time Data Type
|
|
The time data type is used to specify the particular time.
The time is
specified in the form like "hh:mm:ss" where:
- hh indicate the hour
- mm indicate the minute
- ss indicate the second
Note: All the components are required!
The following is an example of a time declaration in the
schema:
|
|
<xs:element name="start" type="xs:time"/>
|
|
|
An element in your document might look as follows:
|
|
|
|
Or it might look as follows:
|
|
<start>09:30:10.5</start>
|
|
|
DateTime Data Type
|
|
The dateTime data type is used to specify the date and a time.
The dateTime can be specified in the following form "YYYY-MM-DDThh:mm:ss"
where:
- YYYY indicate the year
- MM indicate the month
- DD indicate the day
- T indicate the start of the required time section
- hh indicate the hour
- mm indicate the minute
- ss indicate the second
Note: All the components are required!
The following is an example of a dateTime declaration in the
schema:
|
|
<xs:element name="startdate" type="xs:dateTime"/>
|
|
|
An element in your document might look as follows:
|
|
<startdate>2002-05-30T09:00:00</startdate>
|
|
|
Or it might look as follows:
|
|
<startdate>2002-05-30T09:30:10.5</startdate>
|
|
|
Duration Data Type
|
|
The duration data type is used to specify the time interval.
The time interval can be specified in the following form "PnYnMnDTnHnMnS"
where:
- P indicate the period (required)
- nY indicate the number of years
- nM indicate the number of months
- nD indicates the number of days
- T indicate the start of a time section (required if you
are going to specify hours, minutes, or seconds)
- nH indicate the number of hours
- nM indicate the number of minutes
- nS indicate the number of seconds
The following is an example of a duration declaration in the
schema:
|
|
<xs:element name="period" type="xs:duration"/>
|
|
|
An the elements in your document might look as follows:
|
|
|
|
The example above indicate a period of five years.
Or it might look as follows:
|
|
<period>P5Y2M10D</period>
|
|
|
The example above indicate a period of five years, two months, and 10 days.
Or it might look as follows:
|
|
<period>P5Y2M10DT15H</period>
|
|
|
The example above indicate a period of five years, two months, 10 days, and 15 hours.
Or it might look as follows:
|
|
|
|
The example above indicate a period of 15 hours.
|
|
Negative Duration
|
|
To specify a negative duration, enter a minus sign before P:
|
|
|
|
The example above indicate a period of minus 10 days.
|
|
Date and Time Data Types
|
| Name |
Description |
| date |
Defines a date value |
| dateTime |
Defines a date and time value |
| duration |
Defines a time interval |
| gDay |
Defines a part of a date - the day (DD) |
| gMonth |
Defines a part of a date - the month (MM) |
| gMonthDay |
Defines a part of a date - the month and day (MM-DD) |
| gYear |
Defines a part of a date - the year (YYYY) |
| gYearMonth |
Defines a part of a date - the year and month (YYYY-MM) |
| time |
Defines a time value |
|
|
Restrictions on Date Data Types
|
|
Restrictions that can be used with the Date data types:
- enumeration
- maxInclusive
- maxExclusive
- minExclusive
- minInclusive
- pattern
- whiteSpace
|
Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
Keywords:
XSD date datatype,sql server datatype,sql server date,xsd date format,sql date datatype,xsd tutorial,sql xsd,xsd format,oracle xsd,xsd xml,xsd examples,xsd dtd,sample xsd,xsd validator,xsd specification,xsd syntax,xsd example,xsd tools
|
|
| HTML Quizes |
|
|
| XML Quizes |
|
|
| Browser Scripting Quizes |
|
|
| Server Scripting Quizes |
|
|
| .NET (dotnet) Quizes |
|
|
| Multimedia Quizes |
|
|
| Web Building Quizes |
|
|
| Java Quizes |
|
|
| Programming Langauges Quizes |
|
|
| Soft Skills Quizes |
|
|
|