Xref: alice comp.databases.oracle.server:60848 Path: alice!news-feed.fnsi.net!netnews.com!europa.netcrusader.net!4.1.16.34!cpk-news-hub1.bbnplanet.com!atl-news-feed1.bbnplanet.com!news.gtei.net!news.ipass.net!not-for-mail From: "David Sisk" Newsgroups: comp.databases.oracle.server References: <37AB8B37.476F2D65@worldnet.att.net> Subject: Re: ok. I give up. Lines: 31 X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Message-ID: Date: Sun, 8 Aug 1999 21:08:15 -0400 X-Complaints-To: abuse@ipass.net X-Trace: news.ipass.net 934160239 209.170.132.245 (Sun, 08 Aug 1999 20:57:19 EDT) NNTP-Posting-Date: Sun, 08 Aug 1999 20:57:19 EDT Organization: iPass.Net Hi: Just make you column a date datatype. Take a look at the to_char function to see what you can get out of a date column. Regards, -- David C. Sisk Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult uncle.scrooge wrote in message <37AB8B37.476F2D65@worldnet.att.net>... > >Plain and simple : If I want to have a column that tracks the current >time in millisecond resolution, >can I do it or not? i.e. I want a timestamp, but second resolution is >too "gross". What do I do if I'm importing >data from a database that does have millisecond resolution in it's >columns (i.e. sybase)? > > >Do I need to create my own datatype or smth? > >pls help - thx >