Store TIME in the Oracle
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 13 Aug 2011 22:08:47 -0300
Message-ID: <CAJdDhaPMAXwuKVCXB1one=6n3gY6kdhpZaeTG7T4UVmrkcvAoQ_at_mail.gmail.com>
Hello Friends:
Date: Sat, 13 Aug 2011 22:08:47 -0300
Message-ID: <CAJdDhaPMAXwuKVCXB1one=6n3gY6kdhpZaeTG7T4UVmrkcvAoQ_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 13 2011 - 20:08:47 CDT