Replace Value with value from another Column in SQL

In SQL I have 2 columns, ReportedDate (DATETIME) and ReportedTime (char(5)) with the ReportedDate column always showing 0s for the times, ex. '2022-10-04 00:00:00.000'.

I need to combine the ReportedDate and ReportedTime values from the same row to be displayed in a new column.

The result needs to be of DATETIME data type.

For example:

• ReportedDate: '2022-10-04 00:00:00.000'

• ReportedTime: '10:17'

• Desired end result: '2022-10-04 10:17:00.000'

When I tried this:

SELECT 
    CONVERT(DATETIME, REPLACE(ReportedDate, '00:00:00', CONVERT(time, ReportedTime))) AS StartTime
FROM EventDate

My end result returned ReportedDate with no changes made to it in the new StartTime column, which I suspect is happening because the REPLACE function isn't able to read the ReportedTime value because its not in quotes.

You can use CONCAT to concatenate these two columns

Update:
Based on edit the question is more clear.

> ReportedDate format : '2022-10-04 00:00:00.000'
>
> ReportedTime format: '10:17'
>
> Desired end result: '2022-10-04 10:17:00.000'

This can be achieved as follows :

select
    CONVERT(DATETIME, CONCAT(CONVERT(VARCHAR, ReportedDate, 23), ' ', ReportedTime)) AS StartTime
from EventDate

Here is a more reference for :
How to get different date formats in SQL Server