Server: Msg 195, DATE_FORMAT is not a recognized function name. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Stanton Sent: Friday, February 21, 2003 3:55 PM To: CFAussie Mailing List Subject: [cfaussie] RE: pick record with same date irnoring time
SELECT DATE_FORMAT(dateField,'%Y-%m-%d') as formated date FROM table Cheers Mark ______________ Mark Stanton Web Production Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 www.gruden.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/
