2011/12/6 ben hockey <neonstalw...@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... -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers