From: SourceForge.net <no...@so...> - 2005-12-29 13:54:53
|
Bugs item #1392849, was opened at 2005-12-29 13:54 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1392849&group_id=9028 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: Initial Bug Status: Open Resolution: None Priority: 5 Submitted By: Saugort Garcia (saugortg) Assigned to: Nobody/Anonymous (nobody) Summary: timestamp and math operations behaive wrong Initial Comment: Hi, testing Firbird (Firebird-1.0.3.972-Win32.exe) I get this issue. I thing it is a bug. The sql engine is having trouble doing math operations with timestamps. Look the query and the result: 1/24 is around 0.041667, so current_timestamp+1/24 is not resolved well by firebird engine SQL> select current_timestamp, current_timestamp+1/24,current_timestamp+0.041667 from rdb$database; CURRENT_TIMESTAMP ========================= ========================= ========================= 2005-12-29 08:58:43.0000 2005-12-29 08:58:43.0000 2005-12-29 09:58:43.0288 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=109028&aid=1392849&group_id=9028 |