I wrote a blog post concerning this a while back: http://www.stillnetstudios.com/2007/01/20/comparing-dates-without-times-in-sql-server/
Hope that helps. -Ryan Chad Gray wrote: > I am using MS SQL and have a field with data type DateTime. > > I want to find all records with the day 4/2/2007? > > If I do > WHERE dateCreated = '04/02/2007' > > I get no records and I have lots of records like this in the database: > > 4/2/2007 9:57:57 AM > 4/2/2007 10:57:57 AM > 4/2/2007 5:57:57 AM > 4/2/2007 2:57:57 AM > > I want to keep the time in my data so I don't want to modify the data type. > > How do I write my query to find all records on the day 4/2/2007? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4