Formatting datetime problems importing data from mysql db
 

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

Formatting datetime problems importing data from mysql db
 

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.

"PEA" wrote:

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

Formatting datetime problems importing data from mysql db
 

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

"bj" wrote:

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.

"PEA" wrote:

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