Oracle time data type

14,734

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.

Share:
14,734

Related videos on Youtube

Brian Tompsett - 汤莱恩
Author by

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, 2022

Comments

  • Brian Tompsett - 汤莱恩
    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.