I have split a date into 3 parts (day, month & year).
Currently I have these displayed (via select statement) as x3 columns.
How do I convert this back to a single column (a full datetime column entry) ?
,datepart(day,SetupTime) as 'DAY'
,datepart(month,SetupTime) as 'MTH'
,datepart(year,SetupTime) as 'YEAR'