Re: datatype for time - Please help
From: Matt B. <mcb_at_ds.znet.com>
Date: Tue, 16 Jan 2001 20:28:01 -0800
Message-ID: <t6a7m1ebmvd7f8_at_corp.supernews.com>
Date: Tue, 16 Jan 2001 20:28:01 -0800
Message-ID: <t6a7m1ebmvd7f8_at_corp.supernews.com>
[Quoted] "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 [Quoted] depends on your NLS_DATE parameter at the database level or as a format mask in [Quoted] Oracle Forms. Use TO_CHAR to reformat it as desired.
-Matt Received on Wed Jan 17 2001 - 05:28:01 CET