2011/12/6 ben hockey <neonstalwart@gmail.com>:
>
>
> On 12/6/2011 3:53 PM, Pavel Stehule wrote:
>>
>> I am not sure, if this patch is 100% correct
>>
>> but it does something
>>
>> the name is not ECMA but XSD - I hope, so both formats are same
>
>
> that format works for me. in fact a simple test to see if it would do what
> i hope for would be to open the developer console (firebug, web developer,
> etc) of a browser and take the formatted output and pass it to the Date
> constructor - eg using chrome:
>
>> var a = new Date('2011-12-06T22:46:53.455866+01:00');
> Date
>> a.toDateString();
> "Tue Dec 06 2011"
>> a.toTimeString();
> "16:46:53 GMT-0500 (Eastern Standard Time)"
>
> you can see that the Date was properly created with the time converted to my
> local time zone. this would be of great help to anyone passing data from
> postrgres to a web browser since it eliminates the need to have to transform
> the format somewhere between the database and the browser.
>
> i'm not familiar with the process of getting this feature added to postgres
> - what needs to happen now?
it can be in 9.2 (if will be accepted) - it will be release at summer 2012
http://wiki.postgresql.org/wiki/Submitting_a_Patch
Regards
Pavel Stehule
>
> ben...
