Re: Convert from Seconds-Since-Epoch to Timestamp

From: Jie Liang <jliang(at)ipinc(dot)com>
To: Webb Sprague <wsprague100(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Convert from Seconds-Since-Epoch to Timestamp
Date: 2000-09-21 18:35:30
Message-ID: 39CA54F2.9818B78@ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, Webb,

I am not quit sure what you really want to do, however, I assume that
following maybe
what you mean:

db=# select interval(reltime '12313221 secs');
interval
--------------------
4 mons 22 12:20:21
(1 row)

Webb Sprague wrote:

> Hi all,
>
> How do I convert from seconds (an integer) to
> timestamp?
>
> I am sure it is easy, but I can't find it in the docs,
> so far.
>
> Thanks
> Webb
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.ipinc.com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brian C. Doyle 2000-09-21 18:55:08 Re: Convert from Seconds-Since-Epoch to Timestamp
Previous Message Philip Warner 2000-09-21 18:35:17 Re: [Fwd: Re: no ORDER BY in subselects?]