On Tue, May 18, 2010 at 6:26 PM, Ben Hockey <[email protected]> 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
