Re: ecmascript 5 DATESTYLE

On Tue, May 18, 2010 at 6:26 PM, Ben Hockey  wrote:
> hi,
> i mistakenly had posted this to pgsql-bugs already and got a response (see
> below - edited).  i'm posting here since afaik it is the way i should be
> requesting new features.  my suggestion is to add a DATESTYLE format to
> match the format specified for date time strings in ecmascript 5.
> the following is from the ecmascript 5 specification
> at http://www.ecmascript.org/docs/tc39-2009-043.pdf page 168:
>
> 15.9.1.15 Date Time String Format
>
> ECMAScript defines a string interchange format for date-times based upon a
> simplification of the ISO 8601
>
> Extended Format.  The format is as follows: YYYY-MM-DDTHH:mm:ss.sssZ
>
> ecmascript 5 is the most recent specification for JavaScript and i would
> think that having a DATESTYLE format to simplify interoperability with
> JavaScript applications would be highly desirable.

I don't object, if someone wants to write a patch.  I guess the
question is whether to keep adding named formats, or try to create a
general mechanism to allow the user to specify an arbitrary format, as
we do with to_char().

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company