Oracle time data type
date, oracle, time, types
Solution
Nope, not in Oracle. Check the documentation.
You have datetime data types: DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE.
And you have interval data types: YEAR TO MONTH and DAY TO SECOND.
None of the above contains just hours and minutes.
Problem
Is there anyway to have a variable of type time with this format '14:21'? Only with hours and minutes. I've seen lots of examples but all with seconds, milliseconds and that isn't useful at all for me in this context.