Hi.... this seems to works... but this will need to rewrite all my sql inPHP that uses interval.... can i make this default in postgres.conf or something similar...
Thanks... Alan Jairo Acosta On Fri, Nov 21, 2008 at 9:15 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Zagato <[EMAIL PROTECTED]> writes: > > I have som SQL that in 8.0.3 do: > > # SELECT '32 hours'::INTERVAL; > > interval > > ----------------- > > @ 1 day 8 hours > > (1 row) > > > And in 8.3.5 do: > > seg_veh2=# SELECT '@ 32 hours'::INTERVAL; > > interval > > ------------ > > @ 32 hours > > (1 row) > > > Why i unable to get my old style of interval, > > Because '1 day' isn't really the same thing as '24 hours', at least not > if you live anywhere that they have daylight savings time. > > You can probably get the behavior you want by passing the value through > justify_hours(), which does the conversion assuming 1 day == 24 hours. > > regards, tom lane >
