The page "ISO 8601 Date and Time - Converting and implementing" (including the The ISO Poll) has moved to http://www.probabilityof.com/ISO8601.shtml from...
If a persons birthday is unknown do you use a dummy date like 0000-01-01 i use 0000-00-00 with both month and days = 00 for unknown past dates. With a bill...
hjwoudenberg@...
Feb 3, 2006 7:26 pm
1459
This makes sense. Heck, if ISO 8601 allows an hour value of '24' as long as everything else below it is zero, why not do the same with these 'dummy dates'? I...
... Yes, I've done that. I believe we always use 00 for the missing elements, so one field in the database may have a mix of values like 20060203, 20060200,...
I would guess that setting a high month number may default to that equivalent in the new year as elapsed time (like 2006-22-30 may turn into something like...
... The date routines on our platform did not allow for the month or day of 00, so our dates were all just 8-digit numbers. The funny dates did not overflow...
If you don't have a date, you don't have a date. If you don't know the date, you don't have a date. If you don't have a date don't put it in a date field. And...
In a message dated 2/4/2006 12:01:31 P.M. Central Daylight Time, PIEBALDconsult@... writes: If you don't have a date, you don't have a date. If you don't...
hjwoudenberg@...
Feb 5, 2006 7:06 am
1466
... If I don't have a date, I may have a fuzzy date. True, ISO 8601 doesn't handle them, and that limitation that may need to be addressed by either an...
volsano@...
Feb 5, 2006 10:34 am
1467
While I agree the others are fuzzy, the last is 2009-01-20T12:00:00-5:00 when the inaugeration ceremony for the next President will begin. As Bush is in his...
... That was precisely why I identified it as a fuzzy date. It has an absolute latest value (barring changes to the US constitution to extend the present...
volsano@...
Feb 5, 2006 2:19 pm
1469
I disagree as it is a scheduled event. Any meeting, for example, has a theoretical risk of being cancelled, but it still has a scheduled time, and talking...
In a message dated 2/5/2006 5:42:35 A.M. Central Daylight Time, volsano@... writes: That's a pity as it means huge amounts of data about fuzzy dates is...
hjwoudenberg@...
Feb 5, 2006 9:05 pm
1471
Everyone has a birth date. Not every birth date is known. The earth has a birth date. It is not known, only estimated. This world has unknowns and we need a...
hjwoudenberg@...
Feb 5, 2006 9:24 pm
1472
The point is made that 8601 doesn't define ways to communicate values that are not dates, or values that are dates but unknown. It is a good point, although...
... Contrarywise, I love zero, and I wish it were used more often. Especially for tax rates and DST offsets. I just don't want anyone attaching any special...
In a message dated 2/5/2006 7:51:02 P.M. Central Daylight Time, tex@... writes: The 4 examples by Tex are excellent. "Zero is valid as a date" Zero...
hjwoudenberg@...
Feb 6, 2006 3:11 am
1475
yes on zero as a date. I was thinking of year, but of course month and day cannot be. As for needing a standard for these not a date values, make a proposal...
In a message dated 2/5/2006 10:39:24 P.M. Central Daylight Time, tex@... writes: Can you explain a little more what you mean by what I have...
hjwoudenberg@...
Feb 6, 2006 8:08 am
1477
Sorry, I should have punctuated: As for needing a standard for these "Not a Date" values... We were discussing representing unknown and other date values,...
In a message dated 2/6/2006 3:47:50 A.M. Central Daylight Time, tex@... writes: That help? Tex Texin Yep thanks hjw...
hjwoudenberg@...
Feb 6, 2006 5:44 pm
1479
Calculating the start and stop of daylight requires knowing the day of the week This is similar to determining Easter. Pastor Zellar in 1886 developed a...
hjwoudenberg@...
Feb 7, 2006 6:37 am
1480
"Calculating the start and stop of daylight requires knowing the day of the week" Why do you say this? I suspect if you know the latitude and longitude and...
In a message dated 2/7/2006 2:25:35 A.M. Central Daylight Time, tex@... writes: "Calculating the start and stop of daylight requires knowing the day...
hjwoudenberg@...
Feb 7, 2006 8:39 am
1482
Yes a long long time ago. So explain to me why the day of the week matters. Or to put it another way, why does 1/4 of a lunar cycle have any bearing on solar...
In a message dated 2/7/2006 3:55:53 A.M. Central Daylight Time, tex@... writes: So explain to me why the day of the week matters. Or to put it...
hjwoudenberg@...
Feb 7, 2006 9:24 am
1484
The problem is terminology. I am guessing you mean the date when Daylight Saving time starts and stops. I thought you were talking about "daylight"- ie the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
