date format

From: Andreas Lommel <him_lommel_at_t-online.de>
Date: 2000/08/02
Message-ID: <39881712.19300612@news.btx.dtag.de>#1/1

How can I create a table with the date format YYYY.MM.DD ? drop table datest;

create table datest
(

    lfdnr               number(7),
    datum               date 

)
tablespace data01
storage
(

  minextents 1
  maxextents unlimited
)
/ Received on Wed Aug 02 2000 - 00:00:00 CDT