[ptt-users] Milliseconds trouble with analysis data being saved in DB.

[Yuriy]

Hi.  
  
We've found a trouble with analysis data being saved in DB:  
  
Unfortunately MySQL doesn't support   Millisecond DATETIME Resolution (see for details  

                                  http://feedblog.org/2007/05/26/why-doesnt-mysql-support-millisecond-datetime-resolution/              ), so ,for example, you can't extract milliseconds from the field 'T_Start' of the 'transactions' table to make an analytical chart.      
      
We can solve this bug in this way:      
Add a supplementary field of BIGINT type into 'transactions' table and fill this field with datetime long value in the format "yyyyMMddHHmmssSS" during saving results in a DB.      
      
Thanks.      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cake.pushtotest.com/pipermail/users/attachments/20070914/fb5c48e7/attachment-0001.htm