This will probably vary greatly across DBs but here is a mysql version: SELECT * FROM table WHERE DATE_FORMAT(dateField,'%Y-%m-%d') = '2003-02-21'
Cheers Mark --- 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/
