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
3 thoughts on “MS SQL: Create a Date in Transact-SQL”