Re: Data Type: DATETIME supported?

From: Menons <menonm_at_msn.com>
Date: 1996/12/12
Message-ID: <01bbe89f$c6224780$db542499_at_default>#1/1

The Database datatype DATE is used for storing BOTH Date and Time. However, in Oracle Forms, datatype DATE is used for storing ONLY date and DATETIME is used for storing both DATE and TIME.

HTH, Manohar G Menon

Alan Kong <kkkong_at_ee.cuhk.hk> wrote in article <5861sr$ji_at_eng-ser1.erg.cuhk.hk>...
> 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
>
Received on Thu Dec 12 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Frank Wortner: "Re: [Q] How can I add dbshut in shutdown process under AIX?"
Previous message: Menons: "Re: Finding Violated Constraint Name in Pro*C"
In reply to: Alan Kong: "Data Type: DATETIME supported?"
Next in thread: Frank Wortner: "Re: [Q] How can I add dbshut in shutdown process under AIX?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message