Can someone tell me what I've done wrong here, I'm running the below to a "Set variable" @convertFromUtc('2022-01-23 21:50:01', 'New Zealand Standard Time', 'yyyy-MM-dd HH:mm:ss') and getting back the below error The function 'convertFromUtc' expects its first parameter to be a string that contains a UTC date time. The value was '2022-01-23T21:50:01.0000000' I'm pretty certain the same was run last week without error so can't see what I may have had different previously

Hi, I am not sure why this did not work for you but to go on the safe side, You can try to use the default format for the timestamp which is yyyy-MM-ddTHH:mm:ss:fffffffK (complies with ISO 8601 standards). For example in your case: convertFromUtc('2022-01-23T21:50:01','New Zealand Standard Time') Or try to use formatDateTime function: convertFromUtc(formatDateTime('2022-01-23 21:50:01', 'yyyy-MM-ddTHH:mm:ss.fffffffZ'),'New Zealand Standard Time') https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#convertfromutc

Convert from UTC - Microsoft Q&A

Accepted answer

Ronen Ariely 15,096 Reputation points

2022-01-24T00:58:31.51+00:00

Hi,

I am not sure why this did not work for you but to go on the safe side,

You can try to use the default format for the timestamp which is yyyy-MM-ddTHH:mm:ss:fffffffK (complies with ISO 8601 standards). For example in your case: convertFromUtc('2022-01-23T21:50:01','New Zealand Standard Time')

Or try to use formatDateTime function: convertFromUtc(formatDateTime('2022-01-23 21:50:01', 'yyyy-MM-ddTHH:mm:ss.fffffffZ'),'New Zealand Standard Time')

https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#convertfromutc
Please sign in to rate this answer.
Ryan Abbey 1,171 Reputation points

2022-01-24T22:19:28.467+00:00

Yeah, it appears it expects the first parameter to be a full ISO format... the documentation isn't quite clear in that the third parameter is actually an output format rather than an input format (I was seeing this as transforming a date/timestamp to a date/timestamp not string representations of such. It's only when I saw the second example that the issue twigged... not sure how I managed to get a couple of successful runs through with a truncated version of the input value though

Ronen Ariely 15,096 Reputation points

2022-01-27T11:52:48.757+00:00

the documentation isn't quite clear in that the third parameter is actually an output format rather than an input format

You can help improve the document and get credit on doing so as well. The docs are manages on GitHub and anyone can send pull requests (suggestions for update). On the right upper side of the doc you have link to edit the document. All you need is a GitHub account.

not sure how I managed to get a couple of successful runs through with a truncated version of the input value though

The "magics" of commuters is exactly what lead to the uprising computers. Did you not see The Terminator?!?

Ramaka Warrior (bnd) 0 Reputation points

2023-08-25T14:09:45.86+00:00

Perhaps of the T between date and time?
Sign in to comment

Convert from UTC

0 additional answers