MySQL Bugs: #1764: Extending TIMESTAMP to support fractional precision

Bug #1764	Extending TIMESTAMP to support fractional precision
Submitted:	6 Nov 2003 3:05	Modified:	27 Nov 2005 11:38
Reporter:	David Heydon	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	v4.1	OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any

Description:

I'm just having my first look at MySQL with a view to potentially porting an Informix application to MySQL. Looking at the TIMESTAMP datatype, I was surprised to see that it does not appear to support fractions, which seems weird since a database can insert/update many records per second and then its impossible to tell which was inserted/updated first by timestamp alone. I'm used to be able to define timestamps/datetimes with accuracy up to 'YYYY-MM-DD HH:MI:SS.FFFFF'.  

I think this would be a nice enhancement for a future version and would bring it closer in line with Informix/Oracle/DB2 etc, which all support a fractional datetime data type, in one form or another.

Apologies in advance if I've missed anything obvious here!

David

How to repeat:
n/a to a feature request

Would be a great enchancement...
At the moment we cannot use mysql on many
projects because history tables need a
fraction part on datetime columns.

Thank you for a reasonable feature request. I'll mark it as a duplicate of http://bugs.mysql.com/bug.php?id=8523, already verified. There are some plans  already to implement what you asked about.