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")
conn.
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]
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:htt
