From: | Zagato <zagato(dot)gekko(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Interval Format |
Date: | 2008-11-22 01:34:23 |
Message-ID: | 98028b00811211734v425b73bcge79473f402903c63@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi everyone... im looking for some help with the interval format between two
diferents versions of postgres....
I have instaled in my old server postgres 8.0.3 and in my new one postgres
8.3.5...
Everything in both looks works nice but i notice a little difference that is
taking my crazy..
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, i really need to see the day
part.... im using datestyle german in both.... im try with "SET
IntervalStyle TO..." but i get this error:
ERROR: unrecognized configuration parameter "intervalstyle"
looking throw the forums i get that this new param its just for postgres
8.4...
So.. how can i recover my "days" part...
Any help it appreciate... thanks :D
Alan Jairo Acosta
From | Date | Subject | |
---|---|---|---|
Next Message | Milan Oparnica | 2008-11-22 01:37:37 | JOIN results of refcursor functions |
Previous Message | Kevin Duffy | 2008-11-21 20:35:44 | simple text parsing function |