|
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 |
