A wile ago, I had a this error when trying to get the TIME portion of a DATE column: ORA-00904: "TIME": invalid identifier This doesn’t work in Oracle, even though when you search for Oracle convert DATE to TIME*you end up at this page listing TIME as a function:*12.7*Date and Time Functions. ...
More...