Re: timestamp to int

will trillich <will(at)serensoft(dot)com> writes:

> On Tue, Jun 26, 2001 at 09:22:25PM +0200, Tomas Berndtsson wrote:
> > Is there a way to do it the other way around, from an integer to a
> > timestamp?
>
> of course not. don't be silly.
>
> certainly not date_part or to_char or to_date. they're not
> mentioned in the docs, either, so don't bother looking.
> (think of the time you'll save.)
>
> in particular, on my debian system, you wouldn't look in
> /usr/share/doc/postgresql-doc/html/postgres/postgres.htm
> and you wouldn't do
>
> cd /usr/share/doc/postgresql-doc/html/postgres
> grep -i epoch *
>
> that would be bad.

I sense a touch of sarcasm. Yet, having looked (yes, before I mailed,
and now again after), I still can't find a way to create a timestamp
from an integer. You may call me stupid, but I'd be glad to see how
it's done.

Tomas