Don't know what database you're using but, SELECT DISTINCT(TO_DATE(date_field)) FROM table
Will do it in Oracle, assuming that field used to store the dates is in fact of "Date" datatype, not character. Cheers, Rod. -----Original Message----- From: Balaji [mailto:[EMAIL PROTECTED]] Sent: Friday, 21 February 2003 3:08 pm 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/
