Ange Michel POZZO <poange@technologist.com> writes:
> select datetime(abstime( floor (value) ));
> select datetime(abstime( int4 (value) ));
> select datetime(abstime( numeric_int4 (value) ));
> in all case :
> ERROR: pg_atoi: error in "952969611.000000": can't parse ".000000"
That was fixed in January. Update to 7.0 and it'll work fine.
You might be able to make it work in 6.5 like this:abstime(int4(float8(numeric)))
regards, tom lane