web stats
Mirth Community - Search Results

Go Back   Mirth Community > Search Forums

Showing results 1 to 1 of 1
Search took 0.00 seconds.
Search: Posts Made By: madhup1981
Forum: General Discussion 03-04-2015, 12:00 PM
Replies: 3
Views: 8,162
Posted By madhup1981
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...
Showing results 1 to 1 of 1

 
Forum Jump

All times are GMT -8. The time now is 06:42 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation