Oracle time data type
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.
Related videos on Youtube
Brian Tompsett - 汤莱恩
I am a lecturer of Computer Science at the University of Hull. I have worked in the software industry in the US and the UK. I have over 50 years software development experience, in writing compilers, operating system implementation and porting, networking protocol stacks, protocol analysers and software for arcane and unusual architectures. I am experienced at answering and solving students' programming and computer science questions. I teach the networking, compilers and security courses. My research areas include computer crime, forensics and security. I was the first timelord and created the tardis.
Updated on September 14, 2022Comments
-
Brian Tompsett - 汤莱恩 about 1 year
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.