Re: wrong time in m$office
[EMAIL PROTECTED] schrieb:
Bob Ramsey schrieb:
At 04:10 PM 3/11/2003, [EMAIL PROTECTED] wrote:
m$office (office 2000 - win xp) can not handle the time correct.
openoffice (win-xp or redhat-phoebe3) has no problems.
I believe that's a known problem with Microsoft products. They only
appear to be able to handle datetime objects, not date or time. You
might also look up the #DELETED# error on the web for similar problems.
Bob
PS. Cool. This message initially bounced back to me from the mysql
list server because it didn't contain one of the following words:
sql,query,queries,smallin. Your message cannot be posted because it
appears to be either spam or simply off topic to our filter.
Now it should get through.
thanks Bob ;-)
date, datetime, timestamp all are correct in msoffice
time is correctly shown in msquery, but not in access,excel, ...
[...]
perhaps this onehttp://microsoft.com/data/
from http://www.mysql.com/doc/en/MyODBC_clients.html
[...]
seems to work with:
win-xp and office 2000 out of the box with
myodbc-win 3.51
no update needed for ms mdac/jet-service
insert/update -- #deleted (german #geloescht) need:
primarykey(autoincrement)
timestamp
'time'-field shows wrong time or is emptyneed:
'datetime' instead 'time'
msaccess insert eg.for 10:00 -- 1899-12-30 10:00:00
shown as 10:00:00
for 2003-01-01 -- 2003-01-01- 00:00:00
shown as 2003-01-01
do not forget relinking the table!
mysql insert into af (af_dtime_von,af_dtime_bis) values ('18991230
10:00:00','18991230 13:00:00');
works without any problems
msoffice handle the time correct :-)
i will give it a chance @work with windows-users :-(
--
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
Re: wrong time in m$office
At 04:10 PM 3/11/2003, [EMAIL PROTECTED] wrote: m$office (office 2000 - win xp) can not handle the time correct. openoffice (win-xp or redhat-phoebe3) has no problems. I believe that's a known problem with Microsoft products. They only appear to be able to handle datetime objects, not date or time. You might also look up the #DELETED# error on the web for similar problems. Bob PS. Cool. This message initially bounced back to me from the mysql list server because it didn't contain one of the following words: sql,query,queries,smallin. Your message cannot be posted because it appears to be either spam or simply off topic to our filter. Now it should get through. == Bob Ramsey Applications Development Support II ph: 1(319)335-9956 216 Boyd Law Building fax: 1(319)335-9019 University of Iowa College of Law mailto:[EMAIL PROTECTED]Iowa City, IA 52242-1113 For Hardware and Software questions, call 5-9124 == - 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
Re: wrong time in m$office
Bob Ramsey schrieb: At 04:10 PM 3/11/2003, [EMAIL PROTECTED] wrote: m$office (office 2000 - win xp) can not handle the time correct. openoffice (win-xp or redhat-phoebe3) has no problems. I believe that's a known problem with Microsoft products. They only appear to be able to handle datetime objects, not date or time. You might also look up the #DELETED# error on the web for similar problems. Bob PS. Cool. This message initially bounced back to me from the mysql list server because it didn't contain one of the following words: sql,query,queries,smallin. Your message cannot be posted because it appears to be either spam or simply off topic to our filter. Now it should get through. thanks Bob ;-) date, datetime, timestamp all are correct in msoffice time is correctly shown in msquery, but not in access,excel, ... before posting i found a few solutions primarykey-autoincrement, myodbc 3.5x, ... nothing helps! perhaps this onehttp://microsoft.com/data/ from http://www.mysql.com/doc/en/MyODBC_clients.html no! damned :-( @home ok @work no -- 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 - 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
wrong time in m$office
hi, 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 | | | -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
