timediff results imported via ODBC ver. 3.51.27 - feature or issue?
"adas71 Gazeta.pl" <[email protected]> Fri, 8 Oct 2010 12:30:06 +0200
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Hi list, I am trying to import into MS Excel 2003 results from timediff calculation. I am using MS Query to define query to retrieve my data and in MS Query window I get correct results - I mean time in hh:mm:ss format, but after switching to Excel column with results is changed. Excel adds current date to data queried from database. Example: in MS Query: 2010-02-05 05:32:51 | 2010-02-08 07:31:33 | 73:58:42 In Excel 2010-02-05 05:32 2010-02-08 07:31 10-paź-11 01:58:42 I tried to look up is it a feature or a bug, but after hours I am still no sure how to treat this. What are your opinions on this problem? rgds Adam