MQSeries.net :: View topic - using ESQL to insert into smalldatetime type in SQL server

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » using ESQL to insert into smalldatetime type in SQL server

using ESQL to insert into smalldatetime type in SQL server

« View previous topic :: View next topic »

Author

Message

Paul Huang

Posted: Mon Jul 08, 2002 2:18 am Post subject: using ESQL to insert into smalldatetime type in SQL server

Newbie

Joined: 04 Jun 2002
Posts: 8
Location: Taiwan

hi,

I have problem in inserting data using ESQL to a SQL database to a column where the data type is smalldatetime, does anyone has any
clue what may have gone wrong?

Thanks in advance!

TorpedoSTu

Posted: Tue Jul 09, 2002 3:57 am Post subject:

Acolyte

Joined: 14 Nov 2001
Posts: 73

Can you post the ESQL you're trying ?

Regs

Stuart

Bell Hung

Posted: Thu Jul 11, 2002 11:57 pm Post subject:

Newbie

Joined: 05 Dec 2001
Posts: 5
Location: Taiwan

We do a test ,
When
INSERT INTO Database.WODS_T(Ship_Date)
VALUES('2002-07-12 13:13:13');
It work.
But when
DECLARE DT AS TIMESTAMP;
SET DT = CURRENT_TIMESTAMP;
SET DT2 = SUBSTRING(CAST(DT AS CHAR) FROM 12 FOR 19);
INSERT INTO Database.WODS_T(Ship_Date)
VALUES(DT2);
It failed and got SQL State '22008' Datetime overflow

And interesting is in user trace we sow the SQL command is
INSERT INTO WODS_T(Ship_Date) VALUES('2002-07-12 13:13:13:');
and
INSERT INTO WODS_T(Ship_Date) VALUES(?). Parameter is ''2002-07-12 13:13:13''.

The different is only from values or given by parameters list.

Do you have any suggestion ?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » using ESQL to insert into smalldatetime type in SQL server

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP