Re: timstamp

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Fri, 28 Sep 2001 02:37:18 +0100
Message-ID: <9p0obt$m2n$1@phys-ma.sol.co.uk>

There is no boolean in Oracle SQL. Although it is there in PL/SQL it is not there on the tables so we use VARCHAR2(1) with 'Y' and 'N' OR 'T' and 'F'

You could also use NUMBER(1) with 1 and 0 for true false.. Whatever takes your fancy

Lawrence

"Najm Hashmi" <najmh_at_videotron.ca> wrote in message news:9uAq7.2415$kD6.111950_at_weber.videotron.net...
> okay i found it out it is date for timestamp as well... what is equivalent
> for type boolean
> Thanks.
> "Najm Hashmi" <najmh_at_videotron.ca> wrote in message
> news:GkAq7.2283$kD6.108424_at_weber.videotron.net...
> > Hi all, I want to create table using a field download_time of type
> > timestamp. How can I do it in oracle. What is data type equivalent of
> > timestamp for oracle
> > Thanking you all in advance.
> > Regards,
> > Najm
> >
> >
>
>
Received on Thu Sep 27 2001 - 20:37:18 CDT