Re: Store TIME in the Oracle

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Sun, 14 Aug 2011 00:01:23 -0300
Message-ID: <CAJ2dSGS8A0dv=3Af8oqW3QvcF6MPRAWc5kejRaW7H6H8EeWFbQ_at_mail.gmail.com>

Sorry, that was "there isn't a built in TIME datatype"

cheers
Alan.-

On Sun, Aug 14, 2011 at 12:00 AM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:

> I'm going to take a shot and guess you are used to MySQL. Short answer is
> no, there isn't a built in "DATE" datatype. You can define your own
> datatype, but it's a pain.
>
> hth
> Alan.-
>
>
>
> On Sat, Aug 13, 2011 at 10:08 PM, Eriovaldo Andrietta <
> ecandrietta_at_gmail.com> wrote:
>
>> 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-l

Received on Sat Aug 13 2011 - 22:01:23 CDT