Date serial in SQL?

by

Zero is 01 jan 1900 in SQL, so you can use this:

DATEADD(day, @dayval-1,
     DATEADD(month, @monthval-1,
         DATEADD(year, @yearval-1900, 0)
     )
)

Edit, Feb 2018

As the other answer says, since SQL Server 2012 (released after the original answer) we can use DATEFROMPARTS

 SELECT DATEFROMPARTS (@yearval, @monthval, @dayval)

More Related Contents:

  1. How to return only the Date from a SQL Server DateTime datatype
  2. Best approach to remove time part of datetime in SQL Server
  3. SQL “between” not inclusive
  4. I dont know sql syntax for my table [closed]
  5. Get top 1 row of each group
  6. Referring to a Column Alias in a WHERE Clause
  7. Convert Month Number to Month Name Function in SQL
  8. Multiple INSERT statements vs. single INSERT with multiple VALUES
  9. Limit on the WHERE col IN (…) condition
  10. Removing leading zeroes from a field in a SQL statement
  11. Generate a resultset of incrementing dates in TSQL
  12. converting Epoch timestamp to sql server(human readable format)
  13. Better techniques for trimming leading zeros in SQL Server?
  14. How do I split a delimited string so I can access individual items?
  15. Common Table Expression, why semicolon?
  16. What’s the best way to select the minimum value from several columns?
  17. T-SQL split string based on delimiter
  18. Counting DISTINCT over multiple columns
  19. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  20. Why use Select Top 100 Percent?
  21. Correct use of transactions in SQL Server
  22. What is the Null Character literal in TSQL?
  23. SQL Server : SUM() of multiple rows including where clauses
  24. How to combine results of two queries into a single dataset
  25. SQL Server 2005 and temporary table scope
  26. how does SELECT TOP works when no order by is specified?
  27. Check if table exists and if it doesn’t exist, create it in SQL Server 2008
  28. MAX vs Top 1 – which is better?
  29. How to get Previous Value for Null Values
  30. CONCAT_WS() for SQL Server

Leave a Comment