It could be all sorts of things. Why have just 2 codes then? What about unknown but approximately in the present? If that's what you want, then why not just...
1615
hjwoudenberg@...
hjwoudenberg
Apr 14, 2006 4:14 am
In a message dated 4/13/2006 10:50:19 P.M. Central Daylight Time, tex@... writes: It doesn;t need to be part of iso 8601. tex Than who? hjw...
1616
piebaldconsult
Apr 14, 2006 1:14 pm
... The partners in interchange....
1617
piebaldconsult
Apr 14, 2006 1:28 pm
... indicate ... How is that important? Because you say it's important? If the field on a paper form is left blank or marked N/A or some such it's clear what...
1618
piebaldconsult
Apr 14, 2006 5:51 pm
... What about: 2006-04-01T12:30:45.123 2006-W13-6T12:30:45.123 2006-91T12:30:45.123 If the values refer to the same point on the same axis (or plane or ...
1619
piebaldconsult
Apr 14, 2006 6:13 pm
... These would constitute "magic numbers" (as is hour 24) and should be avoided. A NaD should look nothing like a date. You could possibly send only the...
1620
hjwoudenberg@...
hjwoudenberg
Apr 14, 2006 7:09 pm
In a message dated 4/14/2006 8:29:23 A.M. Central Daylight Time, PIEBALDconsult@... writes: How is that important? Because you say it's important? If the...
1621
hjwoudenberg@...
hjwoudenberg
Apr 14, 2006 7:12 pm
In a message dated 4/14/2006 12:53:10 P.M. Central Daylight Time, PIEBALDconsult@... writes: 2006-04-01T12:30:45.123 2006-W13-6T12:30:45.123 ...
1622
hjwoudenberg@...
hjwoudenberg
Apr 14, 2006 7:17 pm
In a message dated 4/14/2006 1:13:31 P.M. Central Daylight Time, PIEBALDconsult@... writes: Also, would you want different values to indicate: A) "I don't...
1623
piebaldconsult
Apr 14, 2006 7:36 pm
... the ... from and ... vendor who ... Looks like a process-specific usage. Another process may want other values. You and your partners in interchange can...
1624
piebaldconsult
Apr 14, 2006 7:45 pm
... (I realized my typo after I posted, and knew it'd be caught.) So 2006-01-01 <> 2006-01-01T00:00 <> 2006-01-01T00:00:00 ? (Oh, and :2004 uses "accuracy";...
1625
Tex Texin
textexin
Apr 14, 2006 7:51 pm
However, you do not need to define NAD for this. Effectively you are using dates so far in the past or future that they cannot possibly conflict with or be...
1626
piebaldconsult
Apr 14, 2006 8:14 pm
Hmm, there's no "Not an Integer" (in any of the various sizes), no "Not a String", no "Not a Boolean"... we'd better get busy and define some of these things...
1627
Tex Texin
textexin
Apr 14, 2006 8:30 pm
First things first: How about a "Not a viable proposal". ;-) However, some of these exist. Often api use -1 or "FFFF" to represent "not a character". And I...
1628
piebaldconsult
Apr 14, 2006 10:17 pm
... Which proposal? Mine was tongue-in-cheek. ... represent "not a ... Depends on the encoding I suppose. ... 65535 Nah, that _is_ an integer. I _do_ some...
1629
Tex Texin
textexin
Apr 14, 2006 10:51 pm
I wasn't referring to yours. I think/hope the topic below is done now. ... From: ISO8601@yahoogroups.com [mailto:ISO8601@yahoogroups.com] On Behalf Of ...
1630
Allan Beatty
allan_beatty
Apr 15, 2006 1:58 am
On Fri, 14 Apr 2006 18:11:35 -0000, piebaldconsult <PIEBALDconsult@...> ... I agree that an empty string is best. If you need to distinguish different...
1631
hjwoudenberg@...
hjwoudenberg
Apr 15, 2006 4:02 pm
In a message dated 4/14/2006 2:39:53 P.M. Central Daylight Time, PIEBALDconsult@... writes: Looks like a process-specific usage. Another process may want...
1632
hjwoudenberg@...
hjwoudenberg
Apr 15, 2006 4:27 pm
Tex, you are the best. In a message dated 4/14/2006 2:51:50 P.M. Central Daylight Time, tex@... writes: Effectively you are using dates so far in...
1633
hjwoudenberg@...
hjwoudenberg
Apr 15, 2006 4:32 pm
In a message dated 4/14/2006 8:59:11 P.M. Central Daylight Time, allan.beatty@... writes: I agree that an empty string is best. Does XML support and empty...
1634
piebaldconsult
Apr 15, 2006 6:41 pm
... and ... Yes, yes, but by the time the value gets to a database it should have been converted to an internal representation, so it won't matter. Also, if...
1635
piebaldconsult
Apr 15, 2006 6:44 pm
... as W3C. ... Therefore, ... will ... effect. It ... I don't see how that applies to ISO 8601. It sounds like internal processing. (What I can make out if...
1636
Pete Forman
pete_forman
Apr 15, 2006 7:50 pm
... All relational databases support NULL. -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by...
1637
piebaldconsult
Apr 15, 2006 8:02 pm
... give the ... A) Change just weighs down my pockets. B) I'm only in favor of changes that _I_ propose. But seriously... 1) I 'm against changes that...
1638
hjwoudenberg@...
hjwoudenberg
Apr 15, 2006 8:06 pm
In a message dated 4/15/2006 1:46:19 P.M. Central Daylight Time, PIEBALDconsult@... writes: I don't see how that applies to ISO 8601. It sounds like...
1639
hjwoudenberg@...
hjwoudenberg
Apr 15, 2006 8:13 pm
In a message dated 4/15/2006 2:50:45 P.M. Central Daylight Time, ... All relational databases support NULL. I am most familiar with DB2: It only supports the...
1640
hjwoudenberg@...
hjwoudenberg
Apr 15, 2006 8:17 pm
In a message dated 4/15/2006 3:02:15 P.M. Central Daylight Time, PIEBALDconsult@... writes: Likewise, if part of your argument is that there should be a...
1641
Tex Texin
textexin
Apr 15, 2006 8:38 pm
I would make a different argument. To be a standard for interchange, it must be usable for all applications. Herman has already stated his proposal meets the...
1642
hjwoudenberg@...
hjwoudenberg
Apr 15, 2006 8:54 pm
Tex, good arguments. In a message dated 4/15/2006 3:39:11 P.M. Central Daylight Time, tex@... writes: To be a standard for interchange, it must be...
1643
hjwoudenberg@...
hjwoudenberg
Apr 15, 2006 8:58 pm
I am not an export on XML but a quick check makes me think XML does not support an empty (*null) value in the date and time data types, fixed size. hjw...
