OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] Re: Where does the "nothing left but toolkits" myth come f

[ Lists Home | Date Index | Thread Index ]

On Wednesday 16 February 2005 03:20 am, Rick Marshall wrote:
> not all databases are backward enough to store dates and numbers in
> binary format

Sorry to put you on the spot rick, but which ones don't? 

I thought most modern databases use a floating point to store datetimes with 
the non-decimal part denoting the day and decimal part denoting the time.

> and you don't necessarily save space in binary formats either - been
> there before too.

A few bytes possibly, not enough to make it worthwhile.

In fact I would assert that a text format:

 Soccer_kickoff@=2005-02-28 T 11:30 AM -10:00

is pretty compact and succinct.

28 bytes of date/time text compared to 8 bytes in a binary format but with
no readability. I don't think that is too bad.

but times are not as often transmitted as dates.


In most business data transfer systems, I think dates get transferred a lot
more than times. But obviously, having a field type that does both is a 
fairly trivial thing.


Computergrid : The ones with the most connections win.


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS