Declare @current_utc_offset int IF  ServerProperty('EngineEdition') >= 5 Begin set @current_utc_offset = (select  conver...

[Read the rest of this article...]

nopcommerce

Declare @current_utc_offset int IF  ServerProperty('EngineEdition') >= 5 Begin set @current_utc_offset = (select  conver...

[Read the rest of this article...]

Deleting guest account from Customer table: SQL Query DELETE Customer FROM Customer LEFT OUTER JOIN [Order] ON Customer.Id = [Order].CustomerI...

[Read the rest of this article...]

nopcommerce

// AZURE SQL USES GREENWICH MEAN TIME . . . Azure SQL Database does not support time zone settings; it always follows UTC. Use AT TIME ZONE in SQ...

[Read the rest of this article...]

UTC

Declare @todays_date Date set @todays_date = CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS date) For example, if you wa...

[Read the rest of this article...]

Azure SQL GetDate()