hello in delphi the type for max(date) if tstring. the only problem is there is no CAST in mysql 3.23.49
bye ----- Original Message ----- From: "Johnny Withers" <[EMAIL PROTECTED]> To: "'Jean Bernard'" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 2:46 PM Subject: RE: problem with max > I'm looking at this right now on an InnoDB table.. > > Only problem is I really have no way to tell the type > of what mysql is returning when I do a max(date). > Since all the date functions work on strings as long > as they are formatted as dates.. > > How are you telling which type is returned? > > --------------------- > Johnny Withers > [EMAIL PROTECTED] > p. 601.853.0211 > c. 601.209.4985 > > -----Original Message----- > From: Jean Bernard [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 24, 2002 5:06 PM > To: [EMAIL PROTECTED] > Subject: problem with max > > > i write a program using MyIsam,and i want uses Innodb. > > the query: > select max(date_comp) as mdate from pieces > > on MyIsam mdate is a date. > on InnoDB mdate is string. > > win2000 > delphi6 > zeosdbo > > it's normal? > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
