Major bug in saving second value in Timestamp attribute

himanshu

Hi Support,

We have identified a major problem in the system where we want to capture the timestamp value with following format "yyyy-MM-dd HH:mm:ss". It does not saving seconds to database or while assigning value from attribute to attribute from two objects.

If anybody else found the same issue please confirm.

Thanks

PointsWell

I think this is a documented MySQL limitation

himanshu

Thanks PW for the response.

Currently I am using MS SQL Express edition. Does this is a limitation of AwareIM or Database ?

PointsWell

Ah, don’t know about MSSQL. Sorry.

Jaymer

H
I just tried it on MS SQL
It does not store seconds - all timestamps end in :00 on my system - latest build v8

Interesting to note the available formats for the timestamp field do not show seconds as an option:
Screen Shot 2017-12-16 at 7.26.58 PM.png

himanshu

Thanks Jaymer for confirming.

Waiting for support response...

aware_support

If you want to store seconds in SQL Server "manually" change the type of the corresponding column in the database from smalldatetime to datetime.

himanshu

Thank you very much.

It works like charm! :mrgreen:

Gabbitas

Hi,

Can anyone confirm that this is a limitation in MySQL? If not how can I store seconds on a timestamp in MySQL?

Thanks

himanshu

Hi,

Can you try to change the datatype DATETIME to DATETIME(3)?