MSSQL – Datetime In Local Timezone

Posted on By David Kittell

This function will get the local time based on the time zone difference from UTC

IF OBJECT_ID(N'[GetLocalDate]') IS NOT NULL
	DROP FUNCTION [GetLocalDate]
GO

CREATE FUNCTION [dbo].[GetLocalDate] (@TimezoneDiffInHour FLOAT = - 5)
RETURNS DATETIME
AS
BEGIN
	RETURN DATEADD(Hh, @TimezoneDiffInHour, GETUTCDATE())
END;

SELECT dbo.GetLocalDate(DEFAULT);
-- or
SELECT dbo.GetLocalDate(-5);

SELECT dbo.GetLocalDate(+1);
Originally Posted on February 2, 2017
Last Updated on March 26, 2021
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Azure Code MSSQL SQL

Related Posts

Truncate

Posted on

public static string Truncate(string source, int length) { if (source.Length > length) { source = source.Substring(0, length); } return source; } Originally Posted on February 21, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code or program…

Read More

Ektron Upload File Into Library

Posted on

I found and modified code to create an Ektron Library File Upload function. This function allows some customization: Defined Folder ID In this code I manually set the folder ID but effectively you could have a drop down list of folders to select the folder (see DMS Widget) Content Title…

Read More

Trim Function

Posted on

–FOR SQL SERVER 2000: CREATE FUNCTION dbo.TRIM(@string VARCHAR(8000)) RETURNS VARCHAR(8000) BEGIN RETURN LTRIM(RTRIM(@string)) END GO –FOR SQL SERVER 2005: CREATE FUNCTION dbo.TRIM(@string VARCHAR(MAX)) RETURNS VARCHAR(MAX) BEGIN RETURN LTRIM(RTRIM(@string)) END GO Source: http://blog.sqlauthority.com/2007/04/24/sql-server-trim-function-udf-trim/ Originally Posted on August 8, 2013Last Updated on October 26, 2015 All information on this site is shared…

Read More