MS-SQL Server says TO_DATE is not a function..
--Bal -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of COLLINS, Rodney Sent: Friday, February 21, 2003 4:02 PM To: CFAussie Mailing List Subject: [cfaussie] RE: pick record with same date irnoring time 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/ --- 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/
