Hi all,
It seems that MS Access can't find out how to "convert" the mysql Time Type
in a table.
Lets say i got 3 colums in a table like this:
create table test (id int(4)auto_increment,dato date,tid time, primary key
(id));
insert into test values ('',curdate(),curtime());
insert into test values ('',curdate(),curtime());
insert into test values ('',curdate(),curtime());
If i do a select * from test then 3 rows occur (offcourse)
mysql> select * from test;
+----+------------+----------+
| id | dato | tid |
+----+------------+----------+
| 1 | 2003-02-26 | 22:50:30 |
| 2 | 2003-02-26 | 22:50:33 |
| 3 | 2003-02-26 | 22:50:34 |
+----+------------+----------+
3 rows in set (0.00 sec)
Now to the "Strange" part.
If i use MS Access and do a import or a Linked tables (sorry cant remember
what is called excatly), then this occur.
id dato tid
1 26-02-2003 30-01-2026 23:52:00
2 26-02-2003 30-01-2026 23:52:00
3 26-02-2003 30-01-2026 23:52:00
If i change the column "tid" in the inputmask in MS Access HH:MM:SS it only
change to
id dato tid
1 26-02-2003 23:52:00
2 26-02-2003 23:52:00
3 26-02-2003 23:52:00
Why?????
Can someone tell me what to do to get this to work??? And i don't wan't to
use another date or timeformat.
Regards
Frank
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
