Skip to Content
XQuery
book

XQuery

by Priscilla Walmsley
March 2007
Intermediate to advanced
512 pages
21h 15m
English
O'Reilly Media, Inc.
Content preview from XQuery

xs:date

The primitive type xs:date represents a date of the Gregorian calendar. The lexical representation of xs:date is YYYY-MM-DD where YYYY represents the year, MM the month, and DD the day. The year value has to be at least four digits, but it can be more than four digits to represent years later than 9999. However, XQuery implementations are not required to support more than four digits. A preceding minus sign (-) can be used to represent years before 0001. A time zone can be added to the end, as described in "Time Zones" in Chapter 19.

Values of type xs:date can be cast to and from xs:dateTime, as described in the section on xs:dateTime. You can obtain the current date using the current-date function, which returns a value of type xs:date.

Table B-3 lists some values of the xs:date type. For more information on working with dates, see Chapter 19.

Table B-3. Values of the xs:date type

Values

Explanation

Valid

 
2006-05-03

May 3, 2006

2006-05-03-05:00

May 3, 2006, U.S. Eastern Standard Time, which is five hours behind Coordinated Universal Time (UTC)

2006-05-03Z

May 3, 2006, Coordinated Universal Time (UTC)

Invalid

 
2006/05/03

Slashes are not allowed as separators

05-03-2006

The value must be in YYYY-MM-DD order

2006-09-31

The date must be valid (September has 30 days)

 

An empty value or zero-length string is not permitted

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

XSLT

XSLT

Doug Tidwell
XPath and XPointer

XPath and XPointer

John Simpson
XQuery Kick Start

XQuery Kick Start

James McGovern, Per Bothner, Kurt Cagle, James Linn, Vaidyanathan Nagarajan

Publisher Resources

ISBN: 0596006349Errata