[SQL] Question on interval

2007-04-20 Thread Wei Weng
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

Re: [SQL] Question on interval

2007-04-20 Thread Rodrigo De León
On 4/20/07, Wei Weng <[EMAIL PROTECTED]> wrote: 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.theInte

Re: [SQL] Question on interval

2007-04-20 Thread Michael Glaesemann
On Apr 20, 2007, at 13:53 , Wei Weng wrote: How do I write a query that converts an interger to the interval type? Like convert integer 10 to INTERVAL '10 seconds'? An easy way to do this is: SELECT 10 * INTERVAL '1 second'; The integer is a column in a table though, so it is more like

Re: [SQL] Question on interval

2007-04-20 Thread Scott Marlowe
On Fri, 2007-04-20 at 13:53, Wei Weng wrote: > 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

Re: [SQL] Question on interval

2007-04-20 Thread Steve Crawford
Rodrigo De León wrote: > On 4/20/07, Wei Weng <[EMAIL PROTECTED]> wrote: >> 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 >> int