Re: Value of a date in Numbers
Re: Value of a date in Numbers
- Subject: Re: Value of a date in Numbers
- From: "Mark J. Reed" <email@hidden>
- Date: Wed, 4 Feb 2009 09:03:00 -0500
ISO 8601. Seriously - it's 2009, you can afford to use 14 to 76 bytes
to store a timestamp.
In any case, Unix timestamps are always unambiguous - well, except for
1-second uncertainties around leap seconds - because they are stored
as a single integer value representing the number of (non-leap)
seconds since 1 January 1970 at midnight GMT. There is no such thing
as a "local timestamp", just the local vs utc representation of a
single unambiguous time value. So any archive format or filesystem
that uses such timestamps is also unambiguous in that regard.
On 2/4/09, Luther Fuller <email@hidden> wrote:
> On Feb 3, 2009, at 6:58 PM, Michelle Steiner wrote:
>
>> On Feb 3, 2009, at 9:31 AM, Luther Fuller wrote:
>>
>>> I think this is a feature. (In fact, I would think recording time
>>> locally would be a bug.) Here's why.
>>
>> However, if you use Applescript to get a date-time from Numbers and
>> enter it into iCal, the time will be off by the offset from GMT.
>
> I was afraid of something like that. Here's a simple thought
> experiment. Suppose someone on the other side of the globe creates a
> file. Sometime later you get a copy of that file. It has a creation
> date.
>
> Question: Can you read that date? Accurate to the second?
>
> Answer: Only if the creation date contains information about the time
> zone where it was created. Preferably, the creation date is stored as
> UTC and knows that.
>
> I don't know if there are any standards for storing dates. There
> should be.
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> AppleScript-Users mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> Archives: http://lists.apple.com/archives/applescript-users
>
> This email sent to email@hidden
>
--
Sent from Gmail for mobile | mobile.google.com
Mark J. Reed <email@hidden>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden