Re: Insert Time only in field DATE

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 22 Jul 2007 17:28:34 +0200
Message-ID: <46a377a1$0$26594$426a74cc@news.free.fr>

"Waleed Harbi" <waleed.harbi_at_gmail.com> a écrit dans le message de news: 1185108732.792070.31410_at_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
|
| 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.

So this is a now the time (in the meaning of date and time) but an interval of time and you have to use INTERVAL datatype.

Regards
Michel Cadot Received on Sun Jul 22 2007 - 10:28:34 CDT