Store TIME in the Oracle

  • From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 13 Aug 2011 22:08:47 -0300

Hello Friends:


  I would like to know if there is a datatype to store only time in oracle,
like HH24:MI

  I can use VARCHAR2(5) and save like that : 01:50, 22:35, ...

  Also, I can use DATE and store only time: HH24:MI , but in this case, it
will store the date too. In this case I need supress data when reading the
table.

  Is there another way to do it ?

Regards
Eriovaldo

Other related posts: