Date and time data types are used for values that contains date and time.
A D V E R T I S E M E N T
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>
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
Be the first one to comment on this page.
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
