On Wed, Sep 10, 2003 at 01:47:20 +0200,
Bruno BAGUETTE <pgsql-ml(at)baguette(dot)net> wrote:
>
> I'm looking for a way to convert a unix timestamp to a PostgreSQL date
> without using ::abstime which seems to be deprecated.
There are other ways to do it, but based on comments from developers
I have seen in the past, abstime isn't going away any time soon.
One other approach would be to multiply a 1 second interval by the
timestamp and add it to a timestamp corresponding to the unix epoch
(00:00:00 on January 1, 1970 if I remember correctly). But your current
method is probably going to be faster.