Re: datatype for time - Please help
Date: Wed, 17 Jan 2001 09:44:57 GMT
Message-ID: <943pio$ghs$1_at_nnrp1.deja.com>
NB - If you are using Forms, set the datatype to DATETIME on the dropdown, otherwise you lose the time element.
In article <t6a7m1ebmvd7f8_at_corp.supernews.com>,
"Matt B." <mcb_at_ds.znet.com> wrote:
> "Cathy" <cathy_at_avkk.yamaha.co.jp> wrote in message
> news:3a651881.0_at_news.tm.net.my...
> > Hi,
> >
> > Can someone please help me I would like to what is the datatype for
time
> >
> > For example:
> >
> > Time_Departure .................
>
> Oracle's date and time are combined in the DATE datatype and the
display format
> depends on your NLS_DATE parameter at the database level or as a
format mask in
> Oracle Forms. Use TO_CHAR to reformat it as desired.
>
> -Matt
>
>
Sent via Deja.com
http://www.deja.com/
Received on Wed Jan 17 2001 - 10:44:57 CET