Timeformat linked tables from Mysql

[snuffi01]

I have an Mysql database and have linked some tables via odbc to an access database (access as an front end).
When i open the tables in access i have some fields that should have a time format, like a phonecalls conect time.
But the strange (for me) is the format of the time in my access table, the format is like this xxxx-xx-xx.
as an example the time 11:56:50 comes out like: 2015-07-05.
I have tried to set the format in access to long time, doesnt work.

Does anyone know how to get the format like xx-xx-xx

best regards

 

[LittleSmudge]

Your problem, I believe, lies in the STORAGE process rather than the retrieval process.

When you store the time into MySQL the MySQL DB is interpreting the data as a DATE rather than a time.


Can you check the Data type of the field in your MySQL database.
MySQL has a DATE type that will store 'dates' ( equivalent of the integer part of Windoz Date/Time values )
MySQL has a TIME type that will store 'times'( equivalent of the sub-integer part of Windoz Date/Time values )
MySQL has a DATETIME type that will store 'full dates & times' ( equivalent of the full Windoz Date/Time value )
MySQL has a TimeStamp type ( that is of no use to you in this context. )

Make sure your table is using the TIME data type.




'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[snuffi01]

The tables in Mysql database is in the TIME data type.
When i look at the posts in the Mysql database it looks fine all fileds with time data type.
But not in Access