#1
|
|||
|
|||
![]()
FAILURE: Error writing to database:
SQLException Conversion failed when converting datetime from character string. Query: INSERT INTO sma values (?, ?,0 ,0,0,0,0,0,0,0,0,0,0) Parameters: [0995819, 200808260357] I am getting this error? How to fix it? |
#2
|
|||
|
|||
![]()
Can you post your channel please?
If you are dealing with any datetime fields from a message make sure they are formatted so that your database can understand them. Post edited by: jbartels, at: 08/28/2008 05:39
__________________
Jon Bartels Zen is hiring!!!! http://consultzen.com/careers/ Talented healthcare IT professionals wanted. Engineers to sales to management. Good benefits, great working environment, genuinely interesting work. |
#3
|
|||
|
|||
![]()
How do I address this issue?
insert into table_name (first_name,last_name,creation_dt) values(${firstname},${Lastname},cast(${SYSTIME} as DATETIME)). I have tried to use cast and convert but still unable to insert data into the table. We are using SQL db and the column is datetime type. Can you please suggest a way to address this? |
#4
|
|||
|
|||
![]()
Valuable information. Thank you for sharing.
__________________
Clinical Research |
![]() |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Best practises - How do I ... ? - DateTime conversion | nshaik | Support | 2 | 10-22-2009 06:29 AM |
Converting HL7 to XML | r_jyothsna | Support | 3 | 06-05-2009 09:16 AM |
Converting HL7 Message from 2.1 to 2.3 | maym2915 | Development | 0 | 10-15-2007 09:51 AM |
Failed to read payload data / Failed to load error mappings | nshaik | Support | 2 | 11-21-2006 02:27 PM |
mapping help, convert HL7 datetime to SOAP dateTime | jbartels | Support | 4 | 11-06-2006 11:41 AM |