m$office (office 2000 - win xp) can not handle the "time" correct. openoffice (win-xp or redhat-phoebe3) has no problems.
what´s wrong?
MyODBC-windows 3.51
$ rpm -q MyODBC MyODBC-2.50.39-11 $ rpm -q mysql-server mysql-server-3.23.54a-4
mysql> describe stunden; +----------------+--------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+------------+-------+ | std_nr | int(10) | YES | | 0 | | | std_bz | varchar(10) | | | | | | std_datum | date | | | 0000-00-00 | | | std_von | time | | | 00:00:00 | | | std_bis | time | | | 00:00:00 | | | std_taetigkeit | varchar(100) | | | | | | std_bemerkung | varchar(20) | YES | | NULL | | +----------------+--------------+------+-----+------------+-------+ 7 rows in set (0.00 sec)
mysql> select std_datum,std_von,std_bis from stunden; +------------+----------+----------+ | std_datum | std_von | std_bis | +------------+----------+----------+ | 2002-07-02 | 14:00:00 | 17:00:00 | | 2002-07-03 | 09:30:00 | 10:00:00 | | 2002-07-03 | 13:00:00 | 13:30:00 | | 2002-07-09 | 10:00:00 | 14:30:00 | | 2002-07-15 | 09:30:00 | 12:30:00 | | 2002-07-16 | 14:00:00 | 17:00:00 | | 2002-07-22 | 11:30:00 | 12:00:00 | | 2002-07-24 | 13:00:00 | 17:00:00 | | 2002-10-11 | 00:00:00 | 00:00:00 | | 2003-12-12 | 01:01:01 | 02:02:02 | +------------+----------+----------+ 10 rows in set (0.00 sec)
results eg. in m$access 02.07.20002 03.07.20002 30.05.2011 23:51:41 03.07.20002 30.05.2015 23:51:41 15.07.20002 30.05.2011 23:51:41 30.05.2016 23:51:41 16.07.20002 30.05.2014 23:51:41 22.07.20002 30.05.2011 23:51:41 24.07.20002 11.10.20002 12.12.20002 30.12.2000 23:51:41 30.01.2002 23:51:41
-- shrek-m
--------------------------------------------------------------------- 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
