SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]

by

In order to be independent of the language and locale settings, you should use the ISO 8601 YYYYMMDD format – this will work on any SQL Server system with any language and regional setting in effect:

SELECT
   CAST(
      CAST(year AS VARCHAR(4)) +
      RIGHT('0' + CAST(month AS VARCHAR(2)), 2) +
      RIGHT('0' + CAST(day AS VARCHAR(2)), 2) 
   AS DATETIME)

More Related Contents:

  1. Sql Server string to date conversion
  2. How to convert SQL Server’s timestamp column to datetime format
  3. How can I truncate a datetime in SQL Server?
  4. What is the significance of 1/1/1753 in SQL Server?
  5. How to get Time from DateTime format in SQL?
  6. How to get first and last day of previous month (with timestamp) in SQL Server
  7. How to remove the time portion of a datetime value (SQL Server)?
  8. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  9. Date conversion and culture: Difference between DATE and DATETIME
  10. SQL Query to find the last day of the month
  11. Handling date in SQL Server
  12. How can I get the sum of multiple datetime values?
  13. Comparing dates stored as varchar
  14. Add default value of datetime field in SQL Server to a timestamp
  15. Best way to store time (hh:mm) in a database
  16. Retrieving the date in SQL Server; CURRENT_TIMESTAMP vs GetDate()
  17. SQL Server Group by Count of DateTime Per Hour?
  18. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  19. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  20. Convert UTC Milliseconds to DATETIME in SQL server
  21. How does SQL Server decide format for implicit datetime conversion?
  22. Undesired rounding of DateTime in SQL Server
  23. How to convert text column to datetime in SQL
  24. How to calculate difference in hours (decimal) between two dates in SQL Server?
  25. Calculate Time Difference Between Two Rows
  26. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”
  27. How to choose the clustered index in SQL Server?
  28. How can I show the table structure in SQL Server query?
  29. INSERT INTO @TABLE EXEC @query with SQL Server 2000
  30. Cannot delete rows from a temporal history table

Leave a Comment