Export time data without date - ADODB Connector

[flubbard]

I am trying to export time data from a MySQL database. I have a time field. When doing a query through the command line (including a select * from ...) I get only the time for that field, when running through the ADODB connector using Visual Basic, the select * from ... command appends a date to the time field. This is undesirable. Is there something within the ADODB connector that could be changed so that the date was not appended to a time record, or is MySQL automatically sending it, in which case how can I make it stop?

Any help would be appreciated.

- Flub

 

[r937]

it's not mysql, not if it's actually a TIME datatype column

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon