[SQL] Question on interval

[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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings