Lazarus
Programming => Databases => Topic started by: eden159 on January 20, 2007, 03:44:37 pm
-
Hi,
I came accross the following problem:
I have a table with a field "tick_time" of type DateTime. I have a record with the following date/time - 01/18/2007 00:00:10.
From Lazarus I make the following query using the Zeos query component:
SELECT * FROM my_table WHERE tick_time='01/18/2007 00:00:10'
I have one record returned - the exact count of records with that exact date/time.
Then I try to convert the extracted "tick_time" and show it to the user:
DateTimeToString(TickString, 'MM/dd/yyyy hh:mm:ss', Query.FieldByName('tick_time').AsDateTime);
ShowMessage(TickString);
The shown value is not 01/18/2007 00:00:10, but 01/18/2007 00:00:09!
When I try it for any other time (the date does not matter), for example 00:00:20 - it works fine.
Does anyone have this bug? Is it a bug or am I missing something?