I have a 3rd party database that I am converting to our datebase and am trying to find the easiest/best way to convert some data.
The source data has the date in char(8) as yyyymmdd and a simple CAST(DATE AS DATETIME) AS OURDATE worked as needed.
With their time field, it isn't working as smoothly... That is in char(6) and it is hhmmss. Should I just plug in a default date and then convert it to datetime? I have tried the following code but it is erroring out...
cast((date+' '+time_rcvd) as datetime) as TRCVD