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]
