Hello,
I am using the MYSQL native database connector under linux with
OpenOffice.org 2.4.
I am having problems entering data into the table viewer of type "time".
When I enter "9:20" into the table it is replaced with "05:46:39 AM".
Also, after the value is entered into OpenOffice and saved, the mysql
command line program shows the value as "-9:20:00". It looks like
there might be an incorrect translation going on.
When I enter the following SQL into the mysql command line program the
time value gets added correctly:
INSERT INTO TS_2_BP (Train,Station,Time) VALUES
("M-800","Tustin","9:20");
I didn't add this to the known bugs because I don't know where the bug
exists. I did find some hits when I searched the mailing list, but I
didn't see anything that stated the problem as fixed or a definitive
explanation.
--Jeff
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
