Re: Data Type: DATETIME supported?

Alan Kong wrote:
>
> When I created table with Data Type: datetime, it reported that it was an
> invalid data type. I wonder wether this datatype is supported in Oracle.
>
> I wanted to save both date and time to an attribute in my database. The
> version of Oracle is: 7.1.3.3.3.
>
> Thank you.
>
> --
> Regards
>
> Alan
>
> *****************************************************************************
> Alan, Kwok-Kee KONG | Email: kkkong_at_ee.cuhk.hk
> Department of Electronic Engineering | alan_at_ee.cuhk.hk
> The Chinese University of Hong Kong | Tel: +852 2609-8286 (voice)
> Shatin, N.T. | +852 2603-5558 (fax)
> Hong Kong
> *****************************************************************************

The Oracle Date datatype supports both date and time. Use the to_char function with a format model of DD-MON-YYYY hh:mi:sssss to see the date and time. Received on Thu Dec 05 1996 - 00:00:00 CET