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:
Category:MySQL Server Severity:S4 (Feature request)
Version:v4.1 OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[6 Nov 2003 3:05] David Heydon

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!


How to repeat:
n/a to a feature request
[14 Jan 2005 17:19] [ name withheld ]
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.
[27 Nov 2005 11:38] Valeriy Kravchuk
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.