Thank you for your response. The information provided has been very useful in my progress
Lance Longstreth Bandag Inc 1-(563)-262-2927 [EMAIL PROTECTED] -----Original Message----- From: Remo Tex [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 7:54 AM To: mysql@lists.mysql.com Subject: Re: Column type problem As seen in manual there's no exact data type for your kind of data: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html see also: http://dev.mysql.com/doc/refman/5.0/en/column-types.html so you can: 1. Use 1 timestamp column and 1 INT column just for milliseconds 2. Use BIGINT [or even DECIMAL with new high-precision arithmetic :-) ] column to store time elapsed since ... some epoch in milliseconds or centiseconds so the wrap-around period is ten times as long. ;-) Yet be carefull with MySQL TIME Type : "The following alternative formats are also understood: SS, MMSS, HHMMSS, HHMMSS.fraction. Note that MySQL doesn't (yet) store the fraction." http://dev.mysql.com/doc/refman/5.0/en/time.html HTH Longstreth, Lance wrote: > > I am trying to create a table to import data on cpu usage based on > certain programs. the following is a sample of the data..... When I > import into the tables their is no field type that matches up to this > type of time data. The field type (time) is close to it but it drops > of the :nn. Is their some way around this? or I'm just out of luck. > > Job time(format(hour:min:sec.nn)) > -------------------- ----------------------------------------------------- > APPLRASI 01:18.9 > APPLRCTL 22.9 > APPLRCUS 08:05.0 > APPLRDLE 26.99 > APPLRDLS 53.3 > ARST831S 22.12 > BAPP0001 4.36 > BAPP0004 5.57 > BAPP0005 8.01 > BAPP0006 5.1 > BAPP0007 23.02 > BAPP0008 2.35 > > > > Lance Longstreth > Bandag Inc > GITS Infrastructure Security and Engineering zOS systems/Linux > [EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
