Re: [SQL] a question about dates and timestamp

[Tom Lane]

Ange Michel POZZO <[EMAIL PROTECTED]> 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