Okies, well the code I sent will do the date but (from your example) will give this result:
21/2/2003 20/2/2003 rather than: 21/02/2003 20/02/2003 if that's important then I'm not sure how to force sql server to give you the extra 0's - James -----Original Message----- From: Balaji [mailto:[EMAIL PROTECTED]] Sent: Friday, 21 February 2003 15:48 To: CFAussie Mailing List Subject: [cfaussie] RE: pick record with same date irnoring time Hi James, I want to pick all distinct dates ignoring time.. there could be something like this. 21/02/2003 10:00:03 21/02/2003 12:06:04 20/02/2003 01:51:22 20/02/2003 01:57:22 I want this result. 21/02/2003 20/02/2003 --Bal -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James MacPherson Sent: Friday, February 21, 2003 3:52 PM To: CFAussie Mailing List Subject: [cfaussie] RE: pick record with same date irnoring time 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/ --- 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/
