If you have a varchar column (late) that holds a timestamp like: 2003-11-01 08:45:12
Can you use this select statement: select * from table where DATE_FORMAT(`late`, '%Y-%m-%d') > '2003-11-01'; Even though the varchar column is not at datetime,timestamp column... Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]