Re: timestamp to int

Alex Pilosov <alex@pilosoft.com> writes:

> On 30 Jun 2001, Tomas Berndtsson wrote:
>
> > > 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.
> Quite strangely, there's no argument for to_date to do conversion from
> 'seconds since epoch'. At any case, this is how you do it:
>
> select 'epoch'::timestamp + (x || ' seconds')::interval

Thank you. That wasn't too obvious to me, but quite logical when
seeing it now.


Tomas