topic Get field date of datebase in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131407#M92328 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have a form that bears a date, I need to get these dates from the database (MySQL), is that the data are stored in ACT_RU_VARIABLE but saves as number that is long because it is larger than this, to be exact is this number 1396933200000, I could work for how to move this issue to date, either in Java or SQL, thank you very much and sorry for the English</SPAN></BODY></HTML> Sat, 29 Jun 2013 14:49:39 GMT j4m01 2013-06-29T14:49:39Z Get field date of datebase https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131407#M92328 Hi,I have a form that bears a date, I need to get these dates from the database (MySQL), is that the data are stored in ACT_RU_VARIABLE but saves as number that is long because it is larger than this, to be exact is this number 1396933200000, I could work for how to move this issue to date, either i Sat, 29 Jun 2013 14:49:39 GMT https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131407#M92328 j4m01 2013-06-29T14:49:39Z Re: Get field date of datebase https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131408#M92329 <HTML><HEAD></HEAD><BODY><SPAN>I don't quite get you question … but:</SPAN><BR /><BR /><SPAN>- Dates are stored as dates. </SPAN><BR /><SPAN>- I don't see how a date can be stored as a number because 'it is too large'</SPAN></BODY></HTML> Mon, 01 Jul 2013 08:48:36 GMT https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131408#M92329 jbarrez 2013-07-01T08:48:36Z Re: Get field date of datebase https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131409#M92330 <HTML><HEAD></HEAD><BODY><SPAN>then that table and dates are stored field</SPAN></BODY></HTML> Tue, 02 Jul 2013 00:29:55 GMT https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131409#M92330 j4m01 2013-07-02T00:29:55Z Re: Get field date of datebase https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131410#M92331 <HTML><HEAD></HEAD><BODY><SPAN>It's really difficult to understand the question. Please elaborate a bit more.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 03 Jul 2013 09:54:28 GMT https://connect.hyland.com/t5/alfresco-archive/get-field-date-of-datebase/m-p/131410#M92331 trademak 2013-07-03T09:54:28Z