<div>
A computed column or function-based index (features in 15.x) to convert the datetime to just data are good solutions <br />

</div>


A computed column or function-based index (features in 15.x) to convert the datetime to just data are good solutions


<div>
Ther world will be a better place when most of us are running &gt;=15 :-)<br />
<br />
Bill
</div>


Ther world will be a better place when most of us are running >=15 :-)

Bill

<div>
<div class="content wysiwyg-content">
I would like to check wethere 2 columns which are of type dateime have the same date.When I test ,I see that<br />
table1.dateT1 = table2.date2 does not work,even though they have the same date time/ Should I have to convert to a string to do the same?<br />

</div>
</div>


I would like to check wethere 2 columns which are of type dateime have the same date.When I test ,I see that
table1.dateT1 = table2.date2 does not work,even though they have the same date time/ Should I have to convert to a string to do the same?


T-SQL datetime equality comparison

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.