Migration from Oracle to azure SQL caveat — Azure SQL does not support time zone settings

Azure SQL Database does not support time zone settings; it always follows UTC. Use AT TIME ZONE in SQL Database if you need to interpret date and time information in a non-UTC time zone.

Time zones in Azure SQL Managed Instance

ALTER FUNCTION dbo.fn_GetCurrentDateTime_PST() 
RETURNS DATETIME
AS
BEGIN

RETURN (SELECT SYSDATETIMEOFFSET() AT TIME ZONE 'Pacific Standard Time')
END
GO

References

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store