Get field date of datebase

[j4m01]

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 in Java or SQL, thank you very much and sorry for the English

[jbarrez]

I don't quite get you question … but:

- Dates are stored as dates.
- I don't see how a date can be stored as a number because 'it is too large'

[j4m01]

then that table and dates are stored field

[trademak]

It's really difficult to understand the question. Please elaborate a bit more.

Best regards,