Formatting datetime problems importing data from mysql db

[Guest]

Hi
I have a mysql db. There is a timestamp in the data formatted like this.
Time Date
11:44:26 22-02-2006
13:56:55 22-02-2006
14:09:35 22-02-2006
14:20:37 22-02-2006
I use ms query to create a query via an odbc connection to the db. When the
datatime is returned it look like this whatever how the cells in excel are
formatted
Time Date
00:00:00 17-01-2006
00:00:00 17-01-2006
00:00:00 17-01-2006
00:00:00 17-01-2006
00:00:00 17-01-2006

What is the problem and how can it be solved?
Regards
PEA

 

[Guest]

if it looks the same no matter what format you have it is coming in as text .
I think the problem is either in your query or data base.

 

[Guest]

Hi
when I look at the time data in the query window before I execute the query
the time is showed correctly
PEA