I'm having a problem with the MyODBC connector whereby when I use it
to retrieve information from a MySQL database and return all the database
into a MS Excel spreadsheet the time column is being reported as 23:52:00
for all the records. The column in the database is called regtime and is of
type TIME. I thought it was a problem with the ODBC connector at first,
because the proper times are being recorded in the database. But on further
investigation, MS Query which is used my MS Excel to retrieve the data from
the database also sees the correct times. I had thought then that it was a
colum formatting problem in Excel, but after having tried several different
column formats, cannot get it to recognise the correct date?
Any ideas anyone?
Neil Robst (neil@stripped)
EMPICS Sports Photo Agency
Direct Line: +44 (0)115 840 4448
Fax: +44 (0)115 840 4443