Re: timestamp to int - Mailing list pgsql-general

From Tomas Berndtsson
Subject Re: timestamp to int
Date
Msg-id 80sngi8fol.fsf@junk.nocrew.org
Whole thread Raw
In response to Re: timestamp to int  (will trillich <will@serensoft.com>)
Responses Re: timestamp to int
List pgsql-general
will trillich <will@serensoft.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

pgsql-general by date:

Previous
From: "Eric G. Miller"
Date:
Subject: Re: Migrating from MSAccess
Next
From: Alex Pilosov
Date:
Subject: Re: timestamp to int