# 4908 DateTimeToAnsiStr Method Not Returning Correct Strings When Seconds Portion is Zero

---

Ran into something interesting and looks like bug to me .

It's related to using Engine.DateTimeToAnsiStr when building timestamp query.

In "dbisamlb" unit and "AnsiTimeToStr" function milliseconds are ONLY added if seconds are not zero.

In my case the timestamp was "2023-04-24 12-57-00.553" and i ended up with clause of "CREATE_TIME <= '2023-04-24 12:57'" which of course finds no records since record was 553 msec further in the future.