You can store the whole thing as a string in one column or store as two
columns: date + milliseconds.
The Oracle DATE type does not support time granularity below one second.
We have used both methods here - just depends on how you want to use the
data later.
Ron Morton
Database Architect / Administrator
Union Switch & Signal Inc
[EMAIL PROTECTED]
> -----Original Message-----
> From: Sinardy Xing [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 2:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: date+time in milliseconds
>
> Hi Raj,
>
> I never heard such time
> Date can handle
> century + year + month + day + hour + minute + second
> but not milliseconds
>
>
> Sinardy
>
>
> -----Original Message-----
> Sent: Tuesday, 8 May 2001 1:14 PM
> To: LazyDBA mailing list
>
>
> can anyone help me with date + time in milliseconds.
> i want to inpurt the data from a user in this format.
> rgds
> raj
>
> _____________________________________________________
> Chat with your friends as soon as they come online. Get Rediff Bol at
> http://bol.rediff.com
>
>
>
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> To unsubscribe: send a blank email to [EMAIL PROTECTED]
> To subscribe: send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy Xing
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Morton, Ronald D
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).