<div>
&gt; resolve differences larger than 0.03 seconds<br />
<br />
Sorry, meant SMALLER than :)<br />
<br />
Regards,<br />
<br />
Patrick
</div>


> resolve differences larger than 0.03 seconds

Sorry, meant SMALLER than :)

Regards,

Patrick

<div>
I could reproduce your problem, I went even a step further (no solution):<br />
<br />
Declare @firstDate DateTime<br />
Select @firstdate = convert(datetime,'6/15/200<wbr />6',101)<br />
declare @lastdate datetime<br />
select @lastdate = convert(datetime, '2006-06-14 23:59:59.999', 121)<br />
Select 1 where @lastdate = @firstDate<br />
select convert(varchar(30), @firstdate, 121), convert(varchar(30), @lastdate, 121)<br />
<br />
Listening &amp;&nbsp;Learning
</div>


I could reproduce your problem, I went even a step further (no solution):

Declare @firstDate DateTime
Select @firstdate = convert(datetime,'6/15/2006',101)
declare @lastdate datetime
select @lastdate = convert(datetime, '2006-06-14 23:59:59.999', 121)
Select 1 where @lastdate = @firstDate
select convert(varchar(30), @firstdate, 121), convert(varchar(30), @lastdate, 121)

Listening & Learning

<div>
realevergod,<br />
<br />
Sorry, the smallest resolution is not 0.03 seconds, but rather 1/300th of a second, or about 0.00333 seconds.<br />
But SQL Server still has to round yours up.<br />
<br />
Regards,<br />
<br />
Patrick
</div>


realevergod,

Sorry, the smallest resolution is not 0.03 seconds, but rather 1/300th of a second, or about 0.00333 seconds.
But SQL Server still has to round yours up.

Regards,

Patrick

<div>
<div class="content wysiwyg-content">
Can anyone tell me why it is that Sql Server 2000 returns 1 on the this?:<br />
<br />
Declare @firstDate DateTime<br />
Select @firstdate = '6/15/2006'<br />
Select 1 where '6/14/2006 23:59:59.999' = @firstDate<br />
<br />
These are two separate DateTime values, but yet SQL Server 2000 seems to think they are equal... This threw a reporting query of mine off simply because the statement returns true in my match criteria.
</div>
</div>


Can anyone tell me why it is that Sql Server 2000 returns 1 on the this?:

Declare @firstDate DateTime
Select @firstdate = '6/15/2006'
Select 1 where '6/14/2006 23:59:59.999' = @firstDate

These are two separate DateTime values, but yet SQL Server 2000 seems to think they are equal... This threw a reporting query of mine off simply because the statement returns true in my match criteria.

SQL2000 - Two different DateTime values return equal

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.