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

Ken Geis created TEIID-5973: ------------------------------- Summary: wrong type info for EPOCH return value Key: TEIID-5973 URL: https://issues.redhat.com/browse/TEIID-5973 Project: Teiid Issue Type: Enhancement Affects Versions: 14.0 Reporter: Ken Geis Assignee: Steven Hawkins 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}   -- This message was sent by Atlassian Jira (v7.13.8#713008)