topic Re: Increased precision in DateTime columns being unused. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182931#M136061 <HTML><HEAD></HEAD><BODY><SPAN>What database are you using? Mysql? If so, are you using mysql 5.6+ ?</SPAN></BODY></HTML> Fri, 16 Jan 2015 11:55:50 GMT jbarrez 2015-01-16T11:55:50Z Increased precision in DateTime columns being unused. https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182930#M136060 I increased the datetime precision in our tables:desc ACT_HI_ACTINST;+——————–+————–+——+—–+———+——-+| Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Null | Key | Default | Extra |+——————–+————–+——+—–+———+——-+| ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | NO&nbsp;&nbsp; | PRI | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || PROC_DEF_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | Tue, 13 Jan 2015 19:16:40 GMT https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182930#M136060 jorell 2015-01-13T19:16:40Z Re: Increased precision in DateTime columns being unused. https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182931#M136061 <HTML><HEAD></HEAD><BODY><SPAN>What database are you using? Mysql? If so, are you using mysql 5.6+ ?</SPAN></BODY></HTML> Fri, 16 Jan 2015 11:55:50 GMT https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182931#M136061 jbarrez 2015-01-16T11:55:50Z Re: Increased precision in DateTime columns being unused. https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182932#M136062 <HTML><HEAD></HEAD><BODY><SPAN>I am using Maria db 10.0.12</SPAN><BR /><SPAN>It does support microsecond precision.</SPAN></BODY></HTML> Fri, 16 Jan 2015 19:32:38 GMT https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182932#M136062 jorell 2015-01-16T19:32:38Z Re: Increased precision in DateTime columns being unused. https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182933#M136063 <HTML><HEAD></HEAD><BODY><SPAN>Some googling led me to this: </SPAN><A href="http://stackoverflow.com/questions/25445807/mariadb-jdbc-settimestamp-truncates-milliseconds" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/25445807/mariadb-jdbc-settimestamp-truncates-milliseconds</A><BR /><BR /><SPAN>Did you try that?</SPAN></BODY></HTML> Wed, 21 Jan 2015 12:59:28 GMT https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182933#M136063 jbarrez 2015-01-21T12:59:28Z