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, M
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 startti
