Combine Date column with Time column 1

[djj55]

Hello, SQL 2008 R2
I have a column of data type DATE and a column of data type TIME.

What is the best way to combine these two column to create a DATETIME column?

Did a search but cannot think of correct search criteria to use.

Thanks,

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[gmmastros]

Convert each column to date time and add them together.

Ex:

Select Convert(DateTime, YourDateColumn) + Convert(DateTime, YourTimeColumn) As [DateTimeColumn]
From   YourTable

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[djj55]

Thank you! I had tried mydate + mytime which of course did not work.

By the way CAST will also work.

Thanks again,

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!