Re: Date format

From: Pierre Ronald <pierrearnold_at_hotmail.com>
Date: 10 Aug 2002 09:10:44 -0700
Message-ID: <ea29f05a.0208100810.2f0ec313@posting.google.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ul8h10frlceo6e_at_corp.supernews.com>...
> "Jayme Assuncao Casimiro" <jayme_at_dcc.ufmg.br> wrote in message
> news:Pine.GSO.4.21.0208091855520.6798-100000_at_turmalina.dcc.ufmg.br...
> >
> > I would like to know how to characterize the miliseconds format in this
> > date format:
> >
> > DATE
> > '2001-08-30 00:00:00.0',
> >
> > FORMAT
> > 'YYYY-MM-DD HH24:MI:SS.?'
> >
> > wHAT DO i PUT in ? to complete the correct format?
> >
> > Thanks
> >
> > --- Jayme
> >
>
> A Date column isn't capable of storing milliseconds.
> Please read the sql reference manual before posting this and similar
> questions.
>
> Hth

create table sybrand_bakker

(newsgroup       varchar2(100),
 social_IQ       number(3),

 human_respect number(3)
 ) tablespace lost_data;  

 insert into sybrand_bakker values
('alt.singles.with.severe.social.dysfunctions',8,0);  COMMIT; Received on Sat Aug 10 2002 - 11:10:44 CDT