Обсуждение: Display format of "great" interval-Values in the query-result is not proper
Display format of "great" interval-Values in the query-result is not proper
От
Andreas Kutschke
Дата:
<ul><li><font size="3">Platform: Windows XP 32</font><li><font size="3">Language: German </font><li><font size="3">Distribution:binary</font><li><font size="3">Version: 1.10.3</font><li><font face="Arial" size="2">Problem: Displayformat of "great" interval-Values in the query-result:</font><br /><img src="cid:_1_05954704059543480032A410C1257762"/><br /><font face="Arial" size="2">-> only the first 24 hours are convertedinto days.</font><br /><font face="Arial" size="2"><br /> Mit freundlichen Gruessen<br /><br /><br /> _______________________________________________________<br/> Dr. Andreas Kutschke<br /> e-mail: Andreas.Kutschke@edag.de<br/> Tel: +49 0661/6000-787<br /> Fax: +49 0661/6000-592(-11-1556)<br /> Voice: +49 0661/6000-12-1556<br/></font></ul><br /><br /><br /><span style="font-family:'Arial',sans-serif; font-size:10pt; color:#000000">Dienächsten Messeauftritte der EDAG Group: IAA-Nutzfahrzeuge in Hannover vom 22.-30.09.2010 in Halle 12, StandC22</span><br /><span style="font-family:'Arial',sans-serif; font-size:10pt; color:#000000"> Innotrans in Berlin vom 21.-24.09.2010 in Halle 1.1, Stand 220</span><br /><span style="font-family:'Arial',sans-serif;font-size:10pt; color:#000000"> HusumWindEnergy in Husum vom 21.-25.09.2010 in Halle 2, Stand D14</span><br /><span style="font-family:'Arial',sans-serif;font-size:10pt; color:#000000"><br /> The EDAG Group's next exhibitions: IAA CommercialVehicles in Hanover, 22 to 30 September 2010 at Stand C22, Hall 12</span><br /><span style="font-family:'Arial',sans-serif;font-size:10pt; color:#000000"> Innotrans in Berlin,21 to 24 September 2010 at Stand 220, Hall 1.1</span><br /><span style="font-family:'Arial',sans-serif; font-size:10pt;color:#000000"> Husum WindEnergy in Husum, 21 to 25 September 2010 atStand D14, Hall 2</span><br /><br /><br /><span style="font-family:sans-serif,helvetica; font-size:10pt; color:#000000">_____________________________________________________<br/></span><span style="font-family:'Arial',sans-serif;font-size:8pt; color:#000000">Court of jurisdiction: Amtsgericht Fulda, HRB 1075 USt.-Id: DE 112 402 594<br /> Geschäftsführung / Executive Board: Jörg Ohlsen: Geschäftsführer / CEO (Product Development+ Production), Manfred Hahl: Geschäftsführer / COO (Manufacturing Equipment + Aerospace), Rainer Bauer: Geschäftsführer/ CFO (Finance)<br /> Aufsichtsratsvorsitzender / Chairman of the Supervisory Board: Dr. Lutz Helmig<br />Persönlich haftende Gesellschafterin / General partner: EDAG Gesellschaft mbH, Wien, Handelsgericht Wien, FN 297836 W<br/> Headquarters: EDAG GmbH & Co. KGaA, Reesbergstraße 1, 36039 Fulda, Germany / www.edag.com</span><br /><br /><br/><span style="font-family:'Arial',sans-serif; font-size:8pt; color:#000000">This e-mail may contain confidential and/orprivileged information. If you are not the intended recipient (or have received this e-mail in error) please notifythe sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the materialin this e-mail is strictly forbidden</span><span style="font-family:sans-serif,helvetica; font-size:8pt; color:#000000">.</span>
Re: Display format of "great" interval-Values in the query-result is not proper
От
Guillaume Lelarge
Дата:
Le 16/07/2010 11:13, Andreas Kutschke a écrit : > * Platform: Windows XP 32 > * Language: German > * Distribution: binary > * Version: 1.10.3 > * Problem: Display format of "great" interval-Values in the > query-result: > > -> only the first 24 hours are converted into days. > AFAICT, this is not an issue with pgAdmin, but with PostgreSQL. I have the same display with psql: b1=# select * from t3; i ------------------00:00:031 day 00:01:0310 days 00:01:031 day 563:56:24563:56:24 (5 lignes) It depends on the way I put them on the table. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com