Postgres Pro
Downloads
Home   >   mailing lists

Question on interval - Mailing list pgsql-sql

From Wei Weng
Subject Question on interval
Date
Msg-id 46290C34.9080507@kencast.com
Whole thread Raw
Responses Re: Question on interval  ("Rodrigo De León" <rdeleonp@gmail.com>)
Re: Question on interval  (Michael Glaesemann <grzm@seespotcode.net>)
Re: Question on interval  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Retrieve month from date
Next
From: "Rodrigo De León"
Date:
Subject: Re: Question on interval