Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Timezone Azure Data Factory
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 18%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
David Tuñon
1
Reputation point
Hi All!!
I want to show timezone in Iso format date (yyyy-MM-ddTHH:mm:ss zzzz), but Data Factory doesn't show this parameter.
Example:
Expression: @formatDateTime(convertTimeZone(pipeline().TriggerTime,'UTC', 'Romance Standard Time'), 'yyyy-MM-ddTHH:mm:ss zzzz')
Output -> "value": "2021-12-03T11:45:19 +00:00"
The output is +00:00, and Romance Standard Time is +01:00, That's error!!
Can anyone helps me?
Best Regards,
David
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HimanshuSinha 19,547 Reputation points Microsoft Employee Moderator2021-12-03T23:27:10.46+00:00 Hello @David Tuñon ,
Thanks for the ask and using the Microsoft Q&A platform .
At this time, we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.
Thanks
Himanshu -
David Tuñon 1 Reputation point
2021-12-04T15:42:50.543+00:00 Hi,
The problem (In dataflow of ADF) appears when I want to store an ISO 8601 format Date in a new String column (New_column in the below examploe).
New_column = toString(toTimestamp(toString(fecha_operacion,"yyyy-MM-dd" ) + hora_operacion, "yyyy-MM-ddHH:mm:ss","Europe/Madrid"),"yyyy-MM-dd'T'HH:mm:ssXXX”)
fecha_operacion -> Date column, example: 2021-11-17
hora_operacion -> String column, example: 17:47:25Output = 2021-11-17T17:47:25Z
The output I expect is -> 2021-11-17T17:47:25+01:00
I think the problem is in toString function because if I convert the timestamp to UTC, It works!! (Like below)
toString(toUTC(toTimestamp(toString(fecha_operacion) + hora_operacion, "yyyy-MM-ddHH:mm:ss", "Europe/Madrid"),"Europe/Madrid"), "yyyy-MM-dd'T'HH:mm:ssXXX")
The output to the above example -> 2021-11-17T16:47:25Z
Best Regards,
David
Sign in to comment
Sign in to answer