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:
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]
I've got a column called time with the datatype time. When querying the
column from asp/ado the values are the current date with a vartype of date.
query browser: select time from syslog.mailinfo limit 1
result:
time
03:18:26
asp/ado:
%set conn=server.createobject(adodb.connection)