Re: Insert Time only in field DATE

From: Waleed Harbi <waleed.harbi_at_gmail.com>
Date: Sun, 22 Jul 2007 12:52:12 -0000
Message-ID: <1185108732.792070.31410@n2g2000hse.googlegroups.com>

On Jul 21, 7:05 pm, sybra..._at_hccnet.nl wrote:
> On Sat, 21 Jul 2007 15:16:17 -0000, Waleed Harbi
>
> <waleed.ha..._at_gmail.com> wrote:
> >I am using Oracle database express edition XE, and I have not found
> >NTERVAL datatype in this version.
> >Your advices please
>
> The datatype is called INTERVAL. 'Have not found' asks for the
> proverbial crystall ball, as you couldn't be bothered to include an
> error message.
> I would suggest to look better. There is separate XE documentation,
> documentation usually lists all datatypes and comes with a master
> index. Reading documentation on your behalf is not the purpose of this
> ng.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Michel,

I did :

SQL> select interval '12:30' hour to minute from dual; INTERVAL'12:30'HOURTOMINUTE

---

+00 12:30:00

And it give me the same results.

>>But what is the meaning of an hour without a day?
because I want calculate the time.

Thanks for everyone. Received on Sun Jul 22 2007 - 07:52:12 CDT