Publié Wed, 19 Dec 2018 18:23:21 GMT par German Andres Quinones Serna Analista de Soporte

Hi Everyone,

I live in Colombia South America, when storing documents automatically in the table of the filer is adding in the fields of the system DWSTOREDATETIME and DWMODDATETIME 5 hours more to which in fact it is stored; Apparently internally DocuWare makes the conversion of hours as if living in Europe, as I fix this situation.

I attach SQL images and the system indexes in DocuWare, the latter if it shows them correctly.

Thank you.

https://www.docuware.com/sites/default/files/forums-images/foro_dw_error_de_fecha_de_almacenamiento_5_horas_mas.png

https://www.docuware.com/sites/default/files/forums-images/foro_dw_error_de_fecha_de_almacenamiento_5_horas_mas_campos_del_sistema.png

Publié Wed, 19 Dec 2018 18:32:28 GMT par Joe Kaufman Manager

Hello,

I am not entirely sure of your question here, but what you are seeing is by design -- all DocuWare date/time fields are stored as UTC values, normalized to a universal time. This makes the data portable (and viewable) across time zones in a way that would not be otherwise possible.

When you view such fields in the web client, they are converted back to your local time zone, as you are seeing.

If you are accessing the data directly from the database, you need to calculate the UTC offset and adjust the date/times yourself if you want to see local time. Most programming environments handle UTC conversions in one way or another these days...

 

Thanks,

Joe Kaufman

Publié Thu, 20 Dec 2018 18:28:34 GMT par German Andres Quinones Serna Analista de Soporte

thanks for your help!!

You must be signed in to post in this forum.