Re: Date DataType ?

From: Breno de Avellar Gomes <brenogomes_at_ieee.org>
Date: Sat, 23 Oct 1999 00:09:32 +0100
Message-ID: <3810EEAC.E1CAD53F@ieee.org>

Oracle standard DATE datatype handles date & time. If you are using Developer see Property Pallete and select an appropriate Format Mask.

SQL> CREATE TABLE your_table (date_info DATE); Table created.

SQL> insert into your_table(date_info) values(sysdate); 1 row created.
sysdate holds current date & time

In SQL*Plus use format mask for date manipulation

SQL> insert into your_table(date_info)
values(to_date('10/22/1999','MM/DD/YYYY')); 1 row created.

SQL> SELECT TO_CHAR(date_info, 'MM/DD/YYYY') FROM your_table;

TO_CHAR(DA

---

10/23/1999
10/22/1999

Allan Clark Allan Clark wrote:

> Is there a data type that takes date and time??
> Do I have to create my own data type to do this?
>
> Thanks
> Allan C

--
Breno de Avellar Gomes
Database Applications & Internet Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
4017-001 Porto
Portugal

brenogomes_at_ieee.org
Cellular: +351 931 7383469
ICQ # 35567342 Toll free fax and voice recorder from USA 1-888-EXCITE2 extension 291-303-8152

Outside USA (international fares apply) 1-917-463-3173 Received on Fri Oct 22 1999 - 18:09:32 CDT