try something like: SELECT * FROM tablename WHERE CONVERT(nvarchar(2), DAY(tablename.column)) + '/' + CONVERT(nvarchar(2), MONTH(tablename.column)) + '/' + CONVERT(nvarchar(4), YEAR tablename.column)) = 'date goes here'
-----Original Message----- From: Balaji [mailto:[EMAIL PROTECTED]] Sent: Friday, 21 February 2003 15:38 To: CFAussie Mailing List Subject: [cfaussie] pick record with same date irnoring time Hi, I want to pick records from a table with distinct dates ignoring time. suggestions pls.. --Bal --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
