'What is the neat approach to combining the date and time value (both of datetime type)?

I am writing a SQL query on table that has 2 columns:

  • StartDate: type - datetime (example: 2022-01-22 00:00:00.000)
  • StartTime: type - datetime (example: 1900-01-01 21:30:00.000)

I want to combine both so as to get the datetime value (example: 2022-01-22 21:30:00.000)

I tried using the DATEADD function, but that expects an interval, which is not suitable for my requirement.

I also tried adding the dates using the + sign which seems to give correct result; and also tried converting the date to int and then doing the + followed by conversion to datetime. This doesn't give correct result.

What is the neat approach to combining the date and time value?

sql-servertsqlsql-server-2019


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions