DWSTOREDATETIME and DWMODDATETIME With 5 hours more in SQL Server Table.-1545247401

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

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

thanks for your help!!