Re: ecmascript 5 DATESTYLE

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: ben hockey <neonstalwart(at)gmail(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Mike Fowler <mike(at)mlfowler(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ecmascript 5 DATESTYLE
Date: 2011-12-07 21:40:34
Message-ID: CAFj8pRBm6DQc5f+igv1THuZ4-93KFPG7fo=S3_BDq7rtCt6Qww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2011/12/7 ben hockey <neonstalwart(at)gmail(dot)com>:
>
> On Dec 7, 2011, at 3:56 PM, Peter Eisentraut wrote:
>
> On tis, 2011-12-06 at 15:15 -0500, Tom Lane wrote:
>
> TBH, I think that inventing a new datestyle setting "ECMA" would be a
>
> more appropriate investment of effort.
>
>
> So we'd have a setting called "ECMA" that's really ISO, and a setting
> called "ISO" that's really SQL, and a setting called "SQL" that's really
> Postgres, and a setting called "Postgres" that's also Postgres but
> different.
>
>
> ...and a setting called "XSD" that's also ISO.
>
> for now i'm backing away from the ECMA option - what i was thinking of would
> be exactly the same as "XSD" except rather than a timezone of '+00:00' it
> would be a 'Z'.  from some quick searching, it seems that XSD should be
> capable of understanding 'Z' rather than '+00:00' so if i was going to do
> anything i'd work towards making that change to 'XSD'.
>
> however, as it turns out, the constraint i have that is requiring me to use
> 'Z' is not actually from ECMAScript 5 but from json-schema
> (http://tools.ietf.org/html/draft-zyp-json-schema-03#section-5.23)  XSD is
> fully compatible with ECMAScript 5 date time string format
> (http://es5.github.com/#x15.9.1.15)  so i'm going to sit on this again for a
> little while and think some more.  maybe try to convince json-schema to
> relax their definition of date-time format.
>
> i'll be back when i have a clear picture of what i think makes the most
> sense.

please do it - we still would to have JSON support, so date style can
be processed together

Regards

Pavel

>
> thanks,
>
> ben...

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marti Raudsepp 2011-12-07 21:58:23 Re: [PATCH] Caching for stable expressions with constant arguments v3
Previous Message Pavel Stehule 2011-12-07 21:37:20 Re: documentation issue - extensions