Re: Pass age function to extract function

Try removing the keyword "interval" (i.e., EXTRACT(MINUTE FROM
TestRunTime)). Since TestRunTime is a column name, I think if you wanted to
cast it as an INTERVAL you'd specify EXTRACT(MINUTE FROM
TestRunTime::INTERVAL), but since TestRunTime is already an INTERVAL, the
cast is redundant.

On Mon, May 2, 2011 at 4:16 PM, Adam Bruss <abruss(at)awrcorp(dot)com> wrote:

> Hello,
>
>
>
> How can one pass a non string literal interval to the extract function?
>
>
>
> For example:
>
>
>
> SELECT starttime, *extract(minute from interval testruntime) as runtime
> from ( select age(endtime, starttime) as testruntime*,
> ref_testnames_serial, starttime, endtime, dense_rank() over (order by
> starttime desc) dr from dtprfrm764.orion_tests where ref_testnames_serial =
> 389 and pass = true) x WHERE dr <= 20 ORDER BY starttime asc
>
>
>
> Does ‘minute from interval’ only accept string literals?
>
>
>
> Thanks,
>
> Adam
>
>
>
> Adam Bruss
>
> Development Engineer
>
> AWR Corporation/Simulation Technology & Applied Research
>
> 11520 N. Port Washington Rd., Suite 201
>
> Mequon, WI 53092 USA
>
> P: 1.262.240.0291 x104
>
> F: 1.262.240.0294
>
> E: abruss(at)awrcorp(dot)com
>
> W: http://www.awrcorp.com
>
>
>

--
Rick Genter
rick(dot)genter(at)gmail(dot)com