Bugs item #2855415, was opened at 2009-09-09 21:01
Message generated for change (Comment added) made by mr-meltdown
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2855415&group_id=56967
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: SQL/Core
Group: SQL CVS Head
Status: Deleted
Resolution: Duplicate
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: adding timestamp + time is impossible
Initial Comment:
sql>select cast('2004-05-01 23:00' as timestamp)+cast('1:00:00' as time);
!types timestamp(7,0) (timestamp) and tinyint(8,0) (bte) are not equal
select cast('2004-05-01 23:00' as timestamp)+3600;
+----------------------------+
| sql_add_single_value |
+============================+
| 2004-05-02 00:00:00.000000 |
+----------------------------+
----------------------------------------------------------------------
>Comment By: Fabian (mr-meltdown)
Date: 2009-09-09 21:04
Message:
PEBKAC
----------------------------------------------------------------------
Comment By: Stefan de Konink (skinkie)
Date: 2009-09-09 21:02
Message:
sf glitch
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2855415&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
