<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to compare a date the time is null in the database.<br />
<br />
sql += &quot;WHERE Return_Time &gt;&nbsp;{ts '2006-03-18 00:00:00'}&quot;;<br />
<br />
I need to compare the date in an SQL query with a date column which has zeroes for the time. &nbsp;But when I use that format in the string I get an SQL exception error.<br />
<br />
Has anyone got an idea how to use correct SQL syntax to do this? &nbsp;I only want to check the date, obviously, since the time is null anyway.<br />
<br />
Thanks,<br />
Bob<br />
<br />
PS your expediency would be appreciated since I am debugging on the client's computer:)
</div>
</div>


Hi,

I need to compare a date the time is null in the database.

sql += "WHERE Return_Time > {ts '2006-03-18 00:00:00'}";

I need to compare the date in an SQL query with a date column which has zeroes for the time.  But when I use that format in the string I get an SQL exception error.

Has anyone got an idea how to use correct SQL syntax to do this?  I only want to check the date, obviously, since the time is null anyway.

Thanks,
Bob

PS your expediency would be appreciated since I am debugging on the client's computer:)

Need the SQL to compare dates with no times

Hi,

I need to compare a date the time is null in the database.

sql += &quot;WHERE Return_Time &gt; {ts &#39;2006-03-18 00:00:00&#39;}&quot;;

I need to compare the date in an SQL query with a date column which has zeroes for the time.  But when I use that format in the string I get an SQL exception error.

Has anyone got an idea how to use correct SQL syntax to do this?  I only want to check the date, obviously, since the time is null anyway.

Thanks,
Bob

PS your expediency would be appreciated since I am debugging on the client&#39;s computer:)

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).