MS SQL: Create a Date in Transact-SQL

Microsoft SQL Server3 Comments on MS SQL: Create a Date in Transact-SQL

MS SQL: Create a Date in Transact-SQL

There is no straight forward function in Transact-SQL to create a simple date based on year, month and day. Below we have created a userdefined function to handle this. Notice that the base date in Microsoft SQL Server is January 1st 1900. We generate the date by adding the year, month and day to the base date.

CREATE function [dbo].[sudf_Common_Date]
(
      @intYear int,
      @intMonth int,
      @intDay int
)
-- returns a datetime value for the specified year, month and day
returns datetime
as
begin
      -- Returns a date later than the base date (1.1.1900)
    return dateadd(month,((@intYear-1900)*12)+@intMonth-1,@intDay-1)
end

Related

Ulf Emsoy has long working experience in project management, software development and supply chain management.

3 thoughts on “MS SQL: Create a Date in Transact-SQL

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top


Subscribe to our newsletter