Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 date in WHERE clause problem

Author  Topic 

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2001-04-03 : 06:26:38
I am trying to filter on a certain date e.g. 19/02/2001

I have something similar to....

SELECT <something>
FROM <table>
WHERE date = '19/02/2001'

this returns nothing although i know there are records with this date. I suspect it is because of the time part but if so how do i ignore the time part of the date.

thx

   

- Advertisement -