Re: Insert Time only in field DATE

From: <sybrandb_at_hccnet.nl>
Date: Sat, 21 Jul 2007 18:05:39 +0200
Message-ID: <5ib4a39j7hfai4kcd70hpv2vn5ghh5lbuf@4ax.com>

On Sat, 21 Jul 2007 15:16:17 -0000, Waleed Harbi <waleed.harbi_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

Received on Sat Jul 21 2007 - 11:05:39 CDT