web stats
Mirth Community - View Single Post - Conversion failed when converting datetime
View Single Post
  #3  
Old 03-04-2015, 01:00 PM
madhup1981 madhup1981 is offline
What's HL7?
 
Join Date: Mar 2015
Posts: 1
madhup1981 is on a distinguished road
Default Conversion failed when converting date and/or time from character string.

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?
Reply With Quote