Forum Discussion
QUESTION::PIPELINE::COPY DATA::MAPPING::DATETIMEOFFSET FORMAT
QUESTION: Does anyone know how to specify correctly the DateTimeOffset format of Copy data activity? ISSUE: The data source is on EST time and the Copy data activity should load the data into a...
THIS!! Ive spent hours on try/repeat to get the correct date time. Run in Oracle and I see the correct timedate. But into the lakehouse and its Pacific mountain. Ive tried multple things and the only thing I can find that works is : from_tz(to_timestamp(to_char(CURRENT_TIMESTAMP , 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS'), 'UTC') at time zone 'America/New_York'. Trying now to cahnge all hundereds of queries to include this.
Elsewhere I also have to explicitly convert and format within data pipelines.