Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Tue May 08 2001 - 06:55:50 CDT
![]() |
![]() |