How to insert Time Stamp for SQL Database

[Former Member]

Hi All,

I need to insert timestamp in milliseconds into the SQL database. The database is taking date but when i'm trying to insert along with the time, it is throwing the following error "Incorrect syntax near 12".

I have given the datatype as DateTime in XI.

Please let me know how i can solve this issue.

Regards,

Manisha Gogineni

[Former Member]

Hi,

Use DateTrans function to translate the source date to target date in the required format. also check in the SQL that column is in DateTime data type.