From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
---|---|
To: | Tomas Berndtsson <tomas(at)nocrew(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: timestamp to int |
Date: | 2001-06-30 13:18:36 |
Message-ID: | Pine.BSO.4.10.10106300916560.7004-100000@spider.pilosoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
-alex
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2001-06-30 13:29:46 | Re: Re: useability of apache, PHP, Postgres for real business apps |
Previous Message | Tomas Berndtsson | 2001-06-30 09:44:58 | Re: timestamp to int |