[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Question on storing Dates for Calendar Items

Subject: Re: Question on storing Dates for Calendar Items
From: David_Marston@xxxxxxxxx
Date: Wed, 21 Mar 2001 10:56:41 -0500
storing dates
Brian Gollwitzer wrote:
>I'm currently using ODBC and ASP to serve up calendar information
>in a table/list format.  The table consists of two columns,
>Event Description and Event Date and is sorted by Event Date.
>The Event Date is stored in the DB as a Date Data Type.
>...
>Using ASP I create the XML file and it looks like below.
>...<date>12-Feb-01</date>
>...What I'm wondering is
>1. What is a good way to store this date information so it can be
>easily sorted.

In terms of current technology, you could use the "Dublin Core"
representation, described at
http://purl.org/DC/documents/rec-dces-19990702.htm
which I believe harmonizes with ISO-8601 (yyyymmdd).

>I know I could just sort the data server-side before writing it to the
>XML file and xsl:for-each running through them in order knowing they
>are already sorted...

This looks like a great idea to me, since the RDBMS suppliers have
extensive experience in query/retrieval optimization.

XML Schemas should provide more options for you. Start looking into
schemas now if you want to be on the laeding edge.
.................David Marston


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.