Re: Date format

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 10 Aug 2002 00:17:46 +0200
Message-ID: <ul8h10frlceo6e@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

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Fri Aug 09 2002 - 17:17:46 CDT