couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Max Ogden <...@maxogden.com>
Subject Re: json date representations
Date Wed, 06 Jul 2011 00:23:12 GMT
ISO8601 is the preferred format because it sorts lexicographically, which
makes it super easy to sort views by date. The JSON.stringify method in
json2.js automatically converts javascript date objects to ISO8601 and
Ecmascript > 1.4 (iirc) natively supports parsing ISO8601

tl;dr always use ISO8601

On Tue, Jul 5, 2011 at 5:05 PM, Patrick Barnes <mrtrick@gmail.com> wrote:

> I use ISO8601 as well; "2010-08-29T13:07:49+10:00"
> (generated using PHP date('c');)
>
>
> On 6/07/2011 9:49 AM, Rudi Benkovič wrote:
>
>> Hi,
>>
>> I'm writing a little CouchDB administration utility and would like to
>> find out how most of you store data values in JSON. From .NET via
>> Newtonsoft's JSON serializer, dates end up in the ISO 8601 as a
>> string, like this:
>>
>> { Timestamp": "2011-05-12T20:52:02.3774261Z" }
>>
>> Let me know what other formats are used, as I'd like to cover as much
>> of them as possible - hopefully the Javascript view code will be able
>> to detect them automatically.
>>
>> Thanks!
>>
>> Rudi
>>
>>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message