Re: Store TIME in the Oracle

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Sun, 14 Aug 2011 00:00:54 -0300
Message-ID: <CAJ2dSGQkOh0XWT2xUALa+Lh5VX5iwWBy3D7cfcZTXKvDUThRew_at_mail.gmail.com>

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:00:54 CDT