|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
![Reply to topic](templates/DAJ_Glass/images/lang_english/reply.gif) |
|
DB INSERT ISSUE |
« View previous topic :: View next topic » |
Author |
Message
|
Trophies |
Posted: Mon Aug 13, 2018 10:41 am Post subject: DB INSERT ISSUE |
|
|
Newbie
Joined: 13 Jun 2018 Posts: 4
|
Hi All,
Environment: IIB 10, MSFT SQL Server DB
So I'd like to make a db insert. My query takes in 4 parameters (3 strings, 1 DateTime value which represents the time my insert was made.)
However, when I use CURRENT_TIME, I get the following error:
Quote: |
SQL State ''22018'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification''
|
I've tried casting into other types and adjusting my format, all to no avail.
Could anyone please look into this and advise?
Many thanks, |
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
Phanikumar |
Posted: Tue Aug 14, 2018 1:49 am Post subject: Re: DB INSERT ISSUE |
|
|
![](images/avatars/gallery/Marvel/movie_x-men_wolverine.gif) Apprentice
Joined: 29 Aug 2016 Posts: 25 Location: Kuwait
|
Trophies wrote: |
Hi All,
Environment: IIB 10, MSFT SQL Server DB
So I'd like to make a db insert. My query takes in 4 parameters (3 strings, 1 DateTime value which represents the time my insert was made.)
However, when I use CURRENT_TIME, I get the following error:
Quote: |
SQL State ''22018'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification''
|
I've tried casting into other types and adjusting my format, all to no avail.
Could anyone please look into this and advise?
Many thanks, |
Show the query you are using _________________ Saying what you feel. It's not being rude, it's called being real. |
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
|
|
![Reply to topic](templates/DAJ_Glass/images/lang_english/reply.gif) |
|
Page 1 of 1 |
|
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
|
|
|
|