INSERT into ... VALUES (TIMESTAMP) problem...

[klaus.schu]

I just receive an error during my CLI ODBC insert statement:
INSERT INTO (.....) VALUES (?, ?, ?, TIMESTAMP( CAST(? AS
VARCHAR(10)),'00:00:00'), ?, ?, ?, ?)";

the ? in the CAST( ) Statement is represented by:
char *go03_btag="10.10.2006";

SQLCODE = -180, SQLSTATE = 22008
MESSAGE: [unixODBC][IBM][CLI Driver][DB2/LINUX] SQL0180N The syntax
of the string representation of a datetime value is incorrect.
SQLSTATE=22007

anyone any idea?
thanks,
Klaus

[rAinDeEr]

hi,

I tried a sample insert and it worked.

------------------------------ Commands Entered
------------------------------
insert into db2nci.test values (TIMESTAMP(CAST('10.10.2006' AS
VARCHAR(10)),'00:00:00'));
------------------------------------------------------------------------------
insert into db2nci.test values (TIMESTAMP(CAST('10.10.2006' AS
VARCHAR(10)),'00:00:00'))
DB20000I The SQL command completed successfully.

RainDeEr

[Serge Rielau]

rAinDeEr wrote:

hi,

I tried a sample insert and it worked.

------------------------------ Commands Entered
------------------------------
insert into db2nci.test values (TIMESTAMP(CAST('10.10.2006' AS
VARCHAR(10)),'00:00:00'));
------------------------------------------------------------------------------
insert into db2nci.test values (TIMESTAMP(CAST('10.10.2006' AS
VARCHAR(10)),'00:00:00'))
DB20000I The SQL command completed successfully.

RainDeEr

May depend on the LOCALE. Try e.g. 10-10-2006

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html