From rdmorton@switch.com Tue, 08 May 2001 04:55:50 -0700 From: "Morton, Ronald D" Date: Tue, 08 May 2001 04:55:50 -0700 Subject: RE: date+time in milliseconds Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@switch.com > -----Original Message----- > From: Sinardy Xing [SMTP:sinardyxing@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@LAZYDBA.com > To subscribe: send a blank email to oracledba-subscribe@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@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@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@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@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).