From: Mikael Fridh [mailto:[EMAIL PROTECTED] > or read about the TIMESTAMP type, but I guess that's too much > precision since you only wanted the date, not the time. > http://www.mysql.com/doc/en/DATETIME.html
It's only too much precision when you're selecting the whole field. You can simply select a timestamp as... SELECT DATE_FORMAT(column, '%Y-%m-%d') AS date ...and get a date just fine. -- Mike Johnson Web Developer/Systems Asst. Smarter Living, Inc. phone (617) 497-2500 x226 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]