Azure SQL Timezone is always UTC. This cannot be changed. For Azure Managed SQL Servers, the timezone can be changed during deployment. However, this cannot be changed after that.
We can create a SQL function to convert the DateTime from UTC to a specific time zone if the dates in local timezone is important for business function.
CREATE FUNCTION dReturnDate( @dFecha as datetime)
RETURNS DATETIME
AS