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.
thanks,
ben...
On May 16, 2010, at 2:22 AM, Pavel Stehule wrote:
I have nothing against some new datestyles - xml, ecma5 and I am able
to add to pg when hackers will agree