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


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] DATEVALUE and TIMEVALUE with full DateTime support

On Wednesday, 2007-03-21 22:19:22 -0500, David A. Wheeler wrote:

> > While speaking of ISO
> > 8601 formats in those functions: ISO specifies an optional 'T' between
> > date an time, to make the string one word for processing, where humans
> > usually write a blank instead. OOo supports the 'T' separator, but no
> > other application seems to. Should we make that a SHOULD? I now did so.
> At least a SHOULD, I think.  Does the ISO standard _require_ supporting the 'T' when separating the date and time?

Yes, it does. ISO 8601:2004 section 4.3.2 "Complete representations" (of
4.3 "Date and time of day") says that the character 'T' shall be used as
a time designator, and adds a note that by mutual agreement of partners
in information interchange the character may be omitted if the
representation is unambiguous.

Since ISO makes you pay (currently 126.00 CHF for ISO 8601) for copies
of standards documents, here are some good public sources:

Here's what ISO's 8601 page says:

| Date and time represents a specified time of a specified day. When use
| is made of the calendar date the representation is:
| YYYY-MM-DDThh:mm:ss
| where the capital letter T is used to separate the date and time
| components. Thus, for a very precise date and time, look at this:
| Example: 2003-04-01T13:01:02 represents one minute and two seconds after
| one o'clock in the afternoon of 2003-04-01. 

Recommended reading:


> We'll need to add tests to check for all this, esp. since we KNOW of implementations that don't do this.

Could you do so before uploading the version of the document I sent you
last night?


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]