Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date format
Interesting... the guy(Sybrand) gives you the answer, you don't say
"thanks", and then you bark about it.
Bob Tyszcenko
Pierre Ronald wrote:
>
> "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 Mon Aug 12 2002 - 09:15:49 CDT