Select * >From table Where convert(varchar, datecreated, 101)='04/02/07'
Jim Gurfein managing member mediaSPA 56 locust avenue | rye | ny 10580 | usa t 914.921.3200 x 101 | m 914.588.9392 | f 914.921.9190 uk | 0207-993-2601 x101 www.mediaspa.com -----Original Message----- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:10 AM To: CF-Talk Subject: Re: SQL question Chad Gray wrote: > I want to find all records with the day 4/2/2007? WHERE DATEDIFF(day, dateCreated,'4/3/2007')=0 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4