Question on interval

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Question on interval
Date: 2007-04-20 18:53:40
Message-ID: 46290C34.9080507@kencast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all.

How do I write a query that converts an interger to the interval type?

Like convert integer 10 to INTERVAL '10 seconds'?

The integer is a column in a table though, so it is more like convert
integer tbl.theInteger to INTERVAL 'tbl.theInteger seconds".

Thanks!

Wei

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rodrigo De León 2007-04-20 19:29:05 Re: Question on interval
Previous Message Scott Marlowe 2007-04-20 17:46:28 Re: Retrieve month from date