DB2 Date

[c***@hotmail.com]

INSERT INTO TABLE1 (tbl_date1, tbl_id)
VALUES ('2007/09/13 12:35:33',6518);

It return db2 error, invalid date ......:<
Any advice?

BTW, how to display the db2 default date format?
Thanks in advance.

[c***@hotmail.com]

I fixed a little bit on the date format,
the date format syntax error is gone.
But it show another error....

INSERT INTO TABLE1 (tbl_date1, tbl_id)
VALUES ('2007-09-13-14.03.14',6518);

The error read: "InternalDataSet: Cursor not returned from Query".
What does this error message mean...?
Thanks in advance.

[Knut Stolze]

Post by c***@hotmail.com
I fixed a little bit on the date format,
the date format syntax error is gone.
But it show another error....
INSERT INTO TABLE1 (tbl_date1, tbl_id)
VALUES ('2007-09-13-14.03.14',6518);
The error read: "InternalDataSet: Cursor not returned from Query".
What does this error message mean...?

This is not a DB2 error message. So you should figure where this message
comes from and what is done there.