Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    El Salvador
    Posts
    1

    Unanswered: help with a SQL query string with mysql

    Iīm a begginner in SQL and mysql and having problems with a query.....

    I need to build an SQL string for using it in Visual Basic to make a query to a table in a mysql 4.012 database. The problem i have is that i`m doing this AVG(field_name) query to a field that has time type. The recordset i receive form the query comes as numeric (integer) format and i need it in hh:mm:ss format. How can i do that????

    thanks in advance

  2. #2
    Join Date
    May 2003
    Location
    Colorado, USA
    Posts
    1
    Have you tried converting that integer into a date after the SQL query finishes?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •