如何将两列组合在一起以在select语句中创建新列？

Hope you can help. I have a Date column and a time column and i want to be able to combine these together within a select statement so there is just one column for [Date and Time]. Everything ive tried seem to add them together instead of combining/appending. Hope you can help. I have a Date column and a t