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 L
I'm a new user with both MySQL and MySQLGU, so this question may be very
simple. When I save query results in MySQLGU, the file shows a MIME file
with a .res extension. I haven't found a program which can open and
directly use the information. Can you help?
Thanks so much.
Gary Simmons
Genera
