Re: mysql types

I'm trying to select a MAX time from a table column, I need to compare this time result with a curtime(). cant seem to tweak it.... As far as I know curtime() returns a time type, and Max returns a string... Dean Hall wrote: > > Can anyone tell me if MySQL is capable of converting types??? > > > > I need to change a time type to a string. > > I believe that most types in MySQL are stored as strings to preserve > accuracy, but I suppose it depends on what you need to do with them. > > > I'm beginning to miss Sybase :-(