Ticket #161 (new enhancement)
Logging to RDBMS in milliseconds
| Reported by: | fcohen | Owned by: | llara@… |
|---|---|---|---|
| Priority: | minor | Milestone: | |
| Version: | 5.3 | Keywords: | |
| Cc: |
Description
Yurly wrote:
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.
Attachments
Change History
Note: See
TracTickets for help on using
tickets.
