Interval Format
От | Zagato |
---|---|
Тема | Interval Format |
Дата | |
Msg-id | 98028b00811211734v425b73bcge79473f402903c63@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Interval Format
|
Список | pgsql-sql |
Hi everyone... im looking for some help with the interval format between two diferents versions of postgres....<br />I haveinstaled in my old server postgres 8.0.3 and in my new one postgres <a href="http://8.3.5.">8.3.5.</a>..<br /> Everythingin both looks works nice but i notice a little difference that is taking my crazy..<br />I have som SQL that in8.0.3 do:<br /># SELECT '32 hours'::INTERVAL;<br /> interval<br />-----------------<br /> @ 1 day 8 hours<br /> (1 row)<br/><br />And in 8.3.5 do:<br />seg_veh2=# SELECT '@ 32 hours'::INTERVAL;<br /> interval<br />------------<br /> @32 hours<br />(1 row)<br /><br clear="all" />Why i unable to get my old style of interval, i really need to see the daypart.... im using datestyle german in both.... im try with "SET IntervalStyle TO..." but i get this error:<br /> ERROR: unrecognized configuration parameter "intervalstyle"<br />looking throw the forums i get that this new param its justfor postgres 8.4...<br />So.. how can i recover my "days" part...<br /><br />Any help it appreciate... thanks :D<br /><br/>Alan Jairo Acosta<br /><br />
В списке pgsql-sql по дате отправления: