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