Bug #11304 milli-seconds, micro-seconds in datetime or timestamp column
Submitted: 14 Jun 2005 2:05 Modified: 30 Jun 2005 8:28
Reporter: Yoshiaki Tajika (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0 OS:Any (*)
Assigned to: CPU Architecture:Any

[14 Jun 2005 2:05] Yoshiaki Tajika 
Description:
I want to set(get) milli-seconds or micro-seconds to(from) DATETIME or TIMESTAMP column.

How to repeat:
N/A(only a request).

Suggested fix:
I thoght I might be able to implement the above feature for myself by using User Defined Function. But I found that I can't guarantee consistency like below.
select udf_timestamp() col1, udf_timestamp() col2;
In this case, col1 and col2 must be just same value for consistency, which is too difficult for me.

As Mysql usage grows, milli-sec and micro-sec become more needed.
For example, 
- recording passage of vast amounts of RFID.
- forensic. I mean andit log of database access for security.
and so on.
[30 Jun 2005 8:28] Geert Vanderkelen 
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

Is same as bug report #8523, http://bugs.mysql.com/bug.php?id=8523

Thanks,
Geert