Hi Tom, On Wednesday 20 April 2005 17:57, Tom Lane wrote: > "Oliver Siegmar" <[EMAIL PROTECTED]> writes: > > select '10.10 secs ago'::interval; > > > > interval > > ------------------- > > @ 10.-10 secs ago > > (1 row) > > What datestyle are you using?
Non-ISO (Postgres in that case), but the handling for non-ISO is all the same in interval.c ... ISO works fine - interval -------------- -00:00:10.10 (1 row) Oliver ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
