I am confused about the behavior of the functions from_utc_timestamp and to_utc_timestamp. As an example, take the following code to a spark shell
So, if interpret correctly, from_utc_timestamp took 02:40 UTC interpreted it as 03:40 GMT+1 (same timestamp) and transformed it to 03:40 UTC. However the description of from_utc_timestamp says
Given a timestamp, which corresponds to a certain time of day in UTC, returns another timestamp that corresponds to the same time of day in the given timezone.
I would have then expected that the function take 02:40 UTC and return 02:40 GMT+1 = 01:40 UTC. In fact, I think the descriptions of from_utc_timestamp and to_utc_timestamp are inverted.
I am interpreting this right?
Thanks in advance