ION ETL Cambiar Zona horaria UTC+0 en Data Lake a UTC-5

unknown

Consulta, estamos consumiendo datos mediante ION ETL, todo normal hasta ahí. Resulta que la zona horaria del Data Lake es UTC+0, pero yo me encuentro en UTC-5, por lo cual necesito establecer una configuración general para que los campos tipo fecha bajen con UTC-5 y no con UTC+0 como actualmente están bajando.

O si conocen de alguna otra configuración que pueda aplicar.

Saludos Cordiales.

Kevin Heiman

translated...  

Query, we are consuming data through ION ETL, everything is normal until then. It turns out that the Data Lake time zone is UTC+0, but I am in UTC-5, so I need to establish a general configuration so that the date type fields go down with UTC-5 and not with UTC+0 as they currently are going down.
Or if you know of any other configuration that can be applied.
Kind regards.

All data is in UTC as you note.  There is a Date Time function FROM_UTC_TIMESTAMP  that should work for you.   In your query and/or in a view.

docs.infor.com/.../default.html

> As this was ION ETL that would only work for Compass approach vs File approach.  For File API approach, this would need to be done on the database  consumer side.  <<<