* [EMAIL PROTECTED] > it seems that "time" gives the hour, minutes, seconds. > is there a way to get tenths and hundreths? > how about without hours?
Not as a data type, but see the DATE_FORMAT() function: <URL: http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333 > > basically, i'm wanting to store lap times for racing. I would convert everything to tenths or hundreths and store it as integers. You could also use a floating point type, like FLOAT or DOUBLE, but be aware of the problems dealing with approximate numbers: <URL: http://www.mysql.com/doc/en/Problems_with_float.html > Note that these problems also apply to the so-called exact types DECIMAL and NUMERIC. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]