himanshu wroteWhen we select timestamp as an attribute type with HH:mm format in AwareIM 7 and We are expecting it will store only time in database like "13:20".
But it is storing timestamp with following format in database "1970-01-01 13:20:00". But we need only time like "13:20".
How we get only time like "13:20"?
Is other way to achieve it?
As I see the datatype of the field in MySQL is DATETIME not TIME when you choose timestamp as the attribute in AwareIM. Unfortunately, there is no Time choice in the type of the attribute in AwareIM.
I think you can change manually on the field in your table at MySQL from DATETIME into TIME. Or maybe the support has any idea for this issue.
As additional, the format of the TIME datatype in MySQL is HH:MM:SS, so... it cannot saved the time as "13:20" but should "13:20:00" (see http://dev.mysql.com/doc/refman/5.7/en/time.html)
