Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group