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?
ben...