RE: date+time in milliseconds

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
rdmorton_at_switch.com

> -----Original Message-----
> From: Sinardy Xing [SMTP:sinardyxing_at_bcsis.com]
> 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 oracledba-unsubscribe_at_LAZYDBA.com
> To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> 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: sinardyxing_at_bcsis.com
>
> 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: ListGuru_at_fatcity.com (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: rdmorton_at_switch.com

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: ListGuru_at_fatcity.com (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).