[SR-Users] save accdb records with milisec in timestamp field

[Uri Shacked]

Hi,

As Daniel wrote, the easiest way (if you start from scratch) will be to set
a new field in DB for millisecond and take it from the message.

Another option will be to install MYSQL version 5.6+ (has support for
millisecond in datetime), create a field of datetime and set it "now()".
The problem, with this is that the time is the time that the data was
inserted to DB.....

Is the limit for millisecond is in the ACCDB module? Or it will work with
millisecond if the DB supports it?

If the limit is in the ACCDB, I think it is better to change it there…

Thanks for the replies,

Uri


On Tue, Apr 23, 2013 at 11:45 AM, Uri Shacked <ushacked at gmail.com> wrote:

> Hi,
>
> can anyone tell me if it is possible to save the time and date using accdb
> (mysql) with milisec as well? the field on the DB is set as TIMESTAMP.
>
> BR,
> Uri
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130424/1c1aecc7/attachment.html>