Bugs item #1841191, was opened at 2007-11-29 11:29
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841191&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: Core
Group: MonetDB5 5.2
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: mharrison (matt_harrison)
Assigned to: Nobody/Anonymous (nobody)
Summary: Timestamp column won't accept insert without time
Initial Comment:
If I create the following table
CREATE TABLE testdate (
id INTEGER NOT NULL,
adate DATE,
adatetime TIMESTAMP,
PRIMARY KEY (id)
)
I can't insert the following:
INSERT INTO testdate (id, adate, adatetime) VALUES (1, '2007-10-30',
'2007-10-30');
It gives the following error:
!SQLException:timestamp:conversion of string '2007-10-30' failed
One could argue that a timestamp is a superset of date, and thus should accept
date formatted input. (I believe mysql, postgres and oracle behave this way).
The databases should just add an implied 00:00:00.000000 for the time portion
of the timestamp value.
ps - the following works, which is sort of confusing too (what does the "0:0"
mean?)
INSERT INTO testdate (id, adate, adatetime) VALUES (2, '2007-10-30',
'2007-10-30 0:0');
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841191&group_id=56967
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
