Hi Hans, the datetime types formats are being specified/standarized by the W3C and by the rfc documents. Please see http://www.w3.org/TR/xmlschema-2/ for details. There are more than 12 types in the set of datetime types for XML. As a crash course I can say that the dateTime XML type valid lexical representaiton is '-'? yyyy '-' mm '-' dd 'T' hh ':' mm ':' ss ('.' s+)? (zzzzzz)? On Thu, Mar 19, 2009 at 4:10 PM, Hans van Rijswijk (DT) wrote:

Hi Lefteris,

Right now we specify a date element as: <createdOn unixtime="12300000000">

With the question "How does an xml representation of a date time object look like?" I meant: How to specify an XML element so it can be interpreted by the date time functions. <somedate datevalue="someStringThatCanBeCastToADateTimeType"> Or <somedate>someStringThatCanBeCastToADateTimeType</somedate>

If we want to supply an XML document and shred it into the database.

And:

How shall this someStringThatCanBeCastToADateTimeType be formatted? - A human readable date string - a Unixtime - some other format

Regards, Hans

...

-----Original Message----- From: Lefteris [mailto:lsidir@gmail.com] Sent: donderdag 19 maart 2009 15:56 To: Communication channel for MonetDB users Subject: Re: [MonetDB-users] Status DateTime support in MonetDB XQuery

Hi,

from the latest MonetDB release notes:

Time and date related types and the comparison and extraction functions on top of them have been implemented in MonetDB/XQuery.

So you will find some support in the latest release:) For more details of what is supported right now you can check http://wiki.pathfinder-xquery.org/wiki/index.php/DateTime_Suppo rt:_Types_and_functions

I dont understand your question on how an xml datetime representation looks like. Do you refer how it looks like internally in MonetDB/Xquery or what is the syntax of XML datetime types?

There are no improvements in the sense of doing datetime specific optimizations. The gain is that the comparison and addition operators for datetimes are optimized as if they were numerics (hence you gain all the performance optimizations you have for numerics) while simplifying the query formulation since you use plain strings that can be casted to datetimes.

lefteris

On Thu, Mar 19, 2009 at 3:44 PM, Hans van Rijswijk (DT) wrote:

...

Hi Monet development team,

Can anyone (e.g. lsidir) tell me what the status is of the development on the date/time support in xquery. If the development has been finished: - In which version of Mserver can I find a working implementation, e.g. source tarball or Fedora 10 RPMs (URL, version, date, stable, daily build)? - How does an xml representation of a date time object look like? - What XQuery extensions can I use to address / compare date objects? - Do you know of any performance improvement / degradation with respect to using date objects? If the development has not been finished: - Same questions, and when is the release planned?

Regards, Hans van Rijswijk.

----------------------------------------------------------------------

...

-------- Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

--------------------------------------------------------------- --------------- Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users