=== modified file 'ChangeLog'
--- ChangeLog	2013-01-16 08:09:16 +0000
+++ ChangeLog	2013-01-16 11:52:58 +0000
@@ -5,6 +5,8 @@
   Bugs fixed:
   * While retrieving data from a field, BLOB to CHAR conversion is done only for 
     fields having BLOB_FLAG, BINARY_FLAG and binary character set(63) (Bug #11746572)
+  * MySQL ODBC drivers incorrectly returns TIME columns, where value > '99:59:59'
+    (Bug #67793)
 
 ----
 

=== modified file 'driver/utility.c'
--- driver/utility.c	2013-01-12 15:39:03 +0000
+++ driver/utility.c	2013-01-16 11:28:56 +0000
@@ -2014,21 +2014,31 @@
 
 my_bool str_to_time_st(SQL_TIME_STRUCT *ts, const char *str)
 { 
-    char buff[12],*to;
+    char buff[12],*to, *tokens[3];
+    int num= 0;
     SQL_TIME_STRUCT tmp_time;
 
     if ( !ts )
         ts= (SQL_TIME_STRUCT *) &tmp_time;
 
+    /* remember the position of the first numeric string */
+    tokens[0]= buff;
+
     for ( to= buff ; *str && to < buff+sizeof(buff)-1 ; ++str )
     {
         if (isdigit(*str))
             *to++= *str;
+        else
+        {
+          /* terminate the string and remember the beginning of the new one */
+          *to++= 0;
+          tokens[++num]= to;
+        }
     }
 
-    ts->hour=   digit(buff[0])*10+digit(buff[1]);
-    ts->minute= digit(buff[2])*10+digit(buff[3]);
-    ts->second= digit(buff[4])*10+digit(buff[5]);
+    ts->hour=   atoi(tokens[0]);
+    ts->minute= atoi(tokens[1]);
+    ts->second= atoi(tokens[2]);
     return 0;
 }
 

=== modified file 'test/my_types.c'
--- test/my_types.c	2012-08-09 12:03:00 +0000
+++ test/my_types.c	2013-01-16 11:28:56 +0000
@@ -1150,6 +1150,32 @@
 }
 
 
+/*
+  Bug #67793 - MySQL ODBC drivers incorrectly returns TIME columns, where 
+  value > '99:59:59'
+*/
+DECLARE_TEST(t_bug67793)
+{
+  SQL_TIME_STRUCT sts;
+  SQLLEN outlen= 0;
+  SQLWCHAR outbuf[5];
+
+  /* make sure we have reset everything to zero */
+  sts.hour= 0;
+  sts.minute= 0;
+  sts.second= 0;
+
+  ok_sql(hstmt, "SELECT CAST('356:59:48' AS TIME)");
+  ok_stmt(hstmt, SQLFetch(hstmt));
+  ok_stmt(hstmt, SQLGetData(hstmt, 1, SQL_TIME, &sts, sizeof(sts), &outlen));
+  is_num(outlen, sizeof(sts));
+  is_num(sts.hour, 356);
+  is_num(sts.minute, 59);
+  is_num(sts.second, 48);
+  return OK;  
+}
+
+
 BEGIN_TESTS
   ADD_TEST(t_longlong1)
   ADD_TEST(t_decimal)
@@ -1173,6 +1199,7 @@
   ADD_TEST(t_sqlnum_to_str)
   ADD_TEST(t_bug31220)
   ADD_TEST(t_bug29402)
+  ADD_TEST(t_bug67793)
 END_TESTS