This content has been marked as final.
Show 2 replies
-
1. Re: Cannot extract time from Oracle
shawkins May 31, 2013 8:41 AM (in response to blaxell)1 of 1 people found this helpfulThat is an odd Oracle limitation - http://docs.oracle.com/cd/B28359_01/server.111/b28286/functions052.htm
"If
HOUR
,MINUTE
, orSECOND
is requested, thenexpr
must evaluate to an expression of datatypeTIMESTAMP
,TIMESTAMP
WITH
TIME
ZONE
,TIMESTAMP
WITH
LOCAL
TIME
ZONE
, orINTERVAL
DAY
TO
SECOND
.DATE
is not valid here, because Oracle Database treats it as ANSIDATE
datatype, which has no time fields."If you want, log an issue for us to compensate for this.
Steve
-
2. Re: Cannot extract time from Oracle
blaxell May 31, 2013 1:01 PM (in response to shawkins)Hi Steve,
thanks a lot for a quick answer! I logged the issue here https://issues.jboss.org/browse/TEIID-2522