AnsweredAssumed Answered

Increased precision in DateTime columns being unused.

Question asked by jorell on Jan 13, 2015
Latest reply on Jan 21, 2015 by jbarrez
I increased the datetime precision in our tables:

desc ACT_HI_ACTINST;
+——————–+————–+——+—–+———+——-+
| Field              | Type         | Null | Key | Default | Extra |
+——————–+————–+——+—–+———+——-+
| ID_                | varchar(64)  | NO   | PRI | NULL    |       |
| PROC_DEF_ID_       | varchar(64)  | NO   |     | NULL    |       |
| PROC_INST_ID_      | varchar(64)  | NO   | MUL | NULL    |       |
| EXECUTION_ID_      | varchar(64)  | NO   | MUL | NULL    |       |
| ACT_ID_            | varchar(255) | NO   |     | NULL    |       |
| TASK_ID_           | varchar(64)  | YES  |     | NULL    |       |
| CALL_PROC_INST_ID_ | varchar(64)  | YES  |     | NULL    |       |
| ACT_NAME_          | varchar(255) | YES  |     | NULL    |       |
| ACT_TYPE_          | varchar(255) | NO   |     | NULL    |       |
| ASSIGNEE_          | varchar(255) | YES  |     | NULL    |       |
| START_TIME_        | datetime(3)  | NO   | MUL | NULL    |       |
| END_TIME_          | datetime(3)  | YES  | MUL | NULL    |       |
| DURATION_          | bigint(20)   | YES  |     | NULL    |       |
| TENANT_ID_         | varchar(255) | YES  |     |         |       |
+——————–+————–+——+—–+———+——-+



But when I check what activiti is writing back to this table the increased precision isnt being used:

select START_TIME_,END_TIME_ from ACT_HI_ACTINST order by START_TIME_ desc limit 5;
+————————-+————————-+
| START_TIME_             | END_TIME_               |
+————————-+————————-+
| 2015-01-13 10:15:23.000 | 2015-01-13 10:15:23.000 |
| 2015-01-13 10:15:21.000 | 2015-01-13 10:15:23.000 |
| 2015-01-13 10:15:20.000 | 2015-01-13 10:15:20.000 |
| 2015-01-13 02:39:59.000 | 2015-01-13 02:39:59.000 |
| 2015-01-13 02:39:59.000 | 2015-01-13 02:39:59.000 |
+————————-+————————-+


I am on version 5.16.

Is there anything I need to do to tell activiti to start using the increased precision?

Outcomes