From: Daevid Vincent
Date: April 24 2003 11:30pm
Subject: RE: Millisecond Precision
List-Archive: http://lists.mysql.com/mysql/138328
Message-Id: <001901c30ab9$92937270$a50aa8c0@Locutus>
MIME-Version: 1.0
Content-Type: text/plain;	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Perhaps you could use the datetime or time fields and create a separate
tinyint field for storing the portions < 1 second. Then just make a few
routines to handle inserting/retrieving the data.

> -----Original Message-----
> From: David Ritter [mailto:ritter@stripped] 
> Sent: Thursday, April 24, 2003 7:24 AM
> To: MySQL General Discussion (E-mail)
> Subject: Millisecond Precision
> 
> 
> Does anyone know if MySQL has any plans on expanding the 
> time, datetime, or
> millisecond types to handle millisecond precision?
> 
> All the other major databases (Oracle, Sybase, DB2, Informix) 
> handle this, it seems a shame that MySQL doesn't.