get the date from datetime in select statement

This question has suggested answer(s)

Hello,

How can I do :

while select dateColumn1, dateColumn2 ....

from myTable

where myTable.dateColumn1 >= myTable.dateColumn2 + 1 // **** I want to compare to date of column + 1 day. How can I do that?

{

// **** ....

}

 

Thanks :)

 

All Replies