Publicado Wed, 19 Dec 2018 18:23:21 GMT por German Andres Quinones Serna - left 05.2021 Comdata Group 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

Publicado Wed, 19 Dec 2018 18:32:28 GMT por Joe Kaufman Bell Laboratories Inc No longer there

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

Publicado Thu, 20 Dec 2018 18:28:34 GMT por German Andres Quinones Serna - left 05.2021 Comdata Group Analista de Soporte

thanks for your help!!

You must be signed in to post in this forum.