How to create a Date in SQL Server given the Day, Month and Year as Integers

by

In SQL Server 2012+, you can use datefromparts():

select datefromparts(@year, @month, @day)

In earlier versions, you can cast a string. Here is one method:

select cast(cast(@year*10000 + @month*100 + @day as varchar(255)) as date)

More Related Contents:

  1. Case statement for multiple columns
  2. SQL where clause odd behavior [closed]
  3. SQL Server Exec issue [closed]
  4. Count(*) vs Count(1) – SQL Server
  5. Selecting data from two different servers in SQL Server
  6. Is a view faster than a simple query?
  7. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  8. How do I delete from multiple tables using INNER JOIN in SQL server
  9. Does Foreign Key improve query performance?
  10. SQL : BETWEEN vs =
  11. SQL Server: Howto get foreign key reference from information_schema?
  12. SQL Server convert string to datetime
  13. Should I design a table with a primary key of varchar or int?
  14. How do you import a large MS SQL .sql file?
  15. How do I make a composite key with SQL Server Management Studio?
  16. Difference between Subquery and Correlated Subquery
  17. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  18. Return number of rows affected by UPDATE statements
  19. Execute Dynamic Query with go in sql
  20. TransactSQL to run another TransactSQL script
  21. How can I get a list of element names from an XML value in SQL Server
  22. SQL server identity column values start at 0 instead of 1
  23. How to rename something in SQL Server that has square brackets in the name?
  24. SQL Server 2008 paging methods?
  25. how to separate string into different columns?
  26. How to compare dates in SQL Server
  27. is it possible to select EXISTS directly as a bit?
  28. Add a row number to result set of a SQL query
  29. Use one CTE many times
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment