Hi, there,
urldb=# create table foo(sec int4);
CREATE
urldb=# insert into foo values(54321);
INSERT 382942319 1
urldb=# select interval(reltime (sec||'secs')) from foo;
interval
--
15:05:21
(1 row)
"Brian C. Doyle" wrote:
> how would you do that with in a query?
>
> ie select date ,
how would you do that with in a query?
ie select date , interval(reltime 'table.secs');
when the value in table.secs = 54321 and "secs" is not a part of it?
At 11:35 AM 9/21/00 -0700, Jie Liang wrote:
>Hi, Webb,
>
>I am not quit sure what you really want to do, however, I assume that
>following
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 in
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/
