Re: Store TIME in the Oracle
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: ecandrietta@xxxxxxxxx
- Date: Sun, 14 Aug 2011 00:01:23 -0300
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@xxxxxxxxx>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@xxxxxxxxx> 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
>>
>>
>>
>
>
Other related posts:
