DateTime database field returns gibberish
Original Reporter info from Mantis: IgD
-
Reporter name: Bob Marietta
Original Reporter info from Mantis: IgD
- Reporter name: Bob Marietta
Description:
I am using Lazarus 0.9.10, the latest Zeoslib (13 Oct 05) and MySQL. I have tried MySQL V4.0.x and V4.1.x. IT WORKS for the most part. However, when i return a datetime field its all garbled. All the other field types work so far. For example...
ShowMessage(FieldByName('mydatetimefield').AsString);
returns "23423-10-7"
If I do a manual SQL query through the command line the database contains the correct date. Is this most likely a bug with Zeoslib, Lazarus or FPC's database support?
Mantis conversion info:
- Mantis ID: 1346
- OS: Windows
- OS Build: XP
- Platform: Win32
- Version: 0.9.10
- Target version: 1.0.0
- LazTarget: 1.0