> -----Original Message----- > From: Dennis Olvany [mailto:[EMAIL PROTECTED] > Sent: 16 August 2005 16:43 > To: mysql@lists.mysql.com > Subject: Change Datatype (time) > > Is there a function that I can use in a query to return > values in a different datatype? I've got a column which is > time datatype and I'd like to return the values in a > vb-compatible datatype. >
You can use DATE_FORMAT() for this: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk http://leithal.cool-tools.co.uk -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.10/73 - Release Date: 15/08/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
