1 message in com.mysql.lists.javaODBC Problem: How Can I link db with ...
FromSent OnAttachments
Mari...@amsinc.com15 Jan 2001 08:10 
Subject:ODBC Problem: How Can I link db with "Time" column
From:Mari...@amsinc.com (Mari@amsinc.com)
Date:01/15/2001 08:10:24 AM
List:com.mysql.lists.java

Hi, Does anybody know how to link a table containing "TIME" type column called "duration".

I've linked that table to Ms Access (2000) but when I go there, I can see rubbish in "duration" column. Microsoft Access expanded time from MySQL db table to full date format (YYYY-MM-DD HH:MM:SS), i.e. "00:17:31" expands to "29/04/2001 23:52:08". That's ridiculous.

P.S. I'm using MyODBC 2.50.36 for NT driver.

Any clues are welcome, Mariusz