@Srinivasan Subramani Thanks for your patience! I had a discussion internally and confirmed that currently this function Adjust DataTime to timezone uses the implicit time zone from dynamic context and converts the input datetime to the implicit time zone.
So, for example, if the transformation takes place with the WestUS implicit context, the time zone is adjusted accordingly. (In most cases this would mean the time zone is adjusted to local time)
So far, we have implemented only a single argument function for this purpose. Taking a second argument for the desired time zone is in our backlog.
do let me know incase of further queries, I would be happy to assist you.