[teiid-issues] [JBoss JIRA] (TEIID-5973) wrong type info for EPOCH return value

wrong type info for EPOCH return value -------------------------------------- Key: TEIID-5973 URL: https://issues.redhat.com/browse/TEIID-5973 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 14.0 Reporter: Ken Geis Assignee: Steven Hawkins Priority: Major Fix For: 15.0, 13.1.2, 14.0.1 Original Estimate: 45 minutes Time Spent: 45 minutes Remaining Estimate: 0 minutes The documentation states that EPOCH(..) and EXTRACT(EPOCH FROM ..) return double. I should be able to perform calculations on those. For example, I should be able to find the number of seconds since the epoch with {code:sql} SELECT EPOCH(NOW()) / 1000; {code} However, this query produces the error {noformat} TEIID30070 The function '(EPOCH(NOW()) / 1000)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.{noformat}