Change Datatype (time)

2005-08-16 Thread Dennis Olvany
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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Change Datatype (time)

2005-08-16 Thread Mark Leith
-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

Re: Change Datatype (time)

2005-08-16 Thread Dennis Olvany
DATE_FORMAT() Doesn't seem like the most elegant solution, but it does seem to work. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]