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

ALTER FUNCTION dbo.fn_GetCurrentDateTime_PST() 
RETURNS DATETIME
AS
BEGIN

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

References

Azure SQL Managed Instance time zones — Azure SQL Managed Instance | Microsoft Docs

--

--

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
Tai Bo

Tai Bo

Backend developer in .NET core. I enjoy the outdoor, hanging out with good friends, reading and personal development.